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
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
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
All of the data on the spreadsheet should be selected. Keyboard shortcut: On the keyboard, press CTRL+Spacebar, then Shift+Spacebar.
By hitting CTRL+C, you can copy all of the data on the sheet.
To create a new blank worksheet, click the plus sign.
To paste the data, click the first cell in the new sheet and hit CTRL+V.
Yes, it is possible to delete some sheets in a copy and delete sheet. The user can select the desired sheets and then click on the Delete option from the menu bar.
The Copy Sheet command copies all of the data in a sheet or worksheet to another sheet or worksheet. The Delete Sheet command deletes an entire sheet from the workbook.
Copy & Delete Sheets is a feature in MS Excel that can be used to delete sheets or worksheets from the workbook without deleting the data or formatting. This is helpful when you want to save space on your hard drive by deleting old sheets and it also allows you to delete a sheet without having to re-enter all of the data.
The best way to use copy and delete sheets is by utilizing them as templates for different types of content that you want to generate - blog posts, web pages, articles etc.
Thank you very much.
I am satisfied.Teaching system is clear and very easy to understand.
I am happy this caurse
I am very happy, Free cuorse big opportunity.
Yes i am so glad to tell it is the best ever platform where i learn many of the features in ms excel and also sir who given a practical knowledge and the way sir explaining is good one thank you learn vern.
The course is very informative but questions asked in quiz section is totally different from what is taught in the video lectures. Please teach those things also which are asked in quiz.
VRUSHALI AJAYRAO GURAD
Diwakar Singh Chauhan
nice teaching language and easy to understand.
I have completed my excel course and my other 3 courses are in process. This is greate plate form to learn any course the teachers are well trained and qualified. Thank you and love you all from PAK.