There are two easy way to copy and paste entire Excel worksheet from one sheet to other worksheet, if you just do copy and paste data from one sheet to other it may be disturb setting and formulas, so I here will show you easy ways to copy and paste worksheet along with setting and formula..
1. First one is so easy right click on worksheet click on “Move or Copy” select “Move to end” and check on “Create a Copy” and than “Ok”
2. Second is select all the cells on the worksheet you just copied into this workbook by pressing Ctrl+A or by clicking on the square in the upper-left corner of the cells, go to new workbook click on square and hit “Enter”
Watch video tutorial.. Please like, share & subscribe
No comments:
Post a comment