Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
If you are facing any issue in playing video please use Firefox browser.
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.
Have a friend to whom you would want to share this course?