How to copy and delete sheet in MS Excel
Now suppose if we want to move our worksheet before and after another
worksheet in status bar, we can simply drag it according to our
requirement.
Now suppose if we want to copy any worksheet with same structure in same
layout to another worksheet then we can right click on that particular
workbook name and select copy option which will create a new same
structured workbook. And then move that copied file according to our
requirement to another workbook.
Suppose if we want to insert a particular row in all the three or four
sheets at once, than we can press 'Shift' key and select all the worksheets
together and then we can insert a row in any one of the workbook which will
automatically insert row in every workbook.
Similarly we can delete any row by selecting all of the worksheet together
at once.
Now suppose if we want to ungroup all the grouped worksheets, we can just
simply right click on any worksheet in status bar and select ungroup
worksheet option.
Share a personalized message with your friends.