How to Delete, insert, Organize, Color, group, Move or Copy work Sheets in Microsoft Excel?
Insert Excel Sheet
If you want store more related data and differentiate various information, you do not need to create multiple spreadsheets or Excel files.
You just need to insert many sheets and customize it as needed.
One simple way of creating a sheet in the same workbook is by pressing “Shift+F11” (Hold Shift key and press F11) You will see a new sheet created.
There is another method to create a new sheet with more options as follows
- Right click on the sheets tab to get the menu like below
- Click on the “Insert” menu
- MS Excel will give you the below option
- I do not want to deviate from this topic, so I am not going to explain all the options here. Click on the worksheet icon or the image
- If you want to choose any other sheet type, like a chart or other downloaded template you can select the same
- Click OK to insert the sheet and Excel will add a new sheet as below
- Most of us want only to insert a plain worksheet so I suggest the fastest way to Press the Shift+F11
How to Delete a sheet?
Right Click on the Sheets Tab and Excel will give a you a menu to select.
Click “Delete”
When you delete a sheet, Excel will ask you for a confirmation, because you cannot get the data back. It will be lost forever.
When you delete a sheet without any data, Excel will not ask for the confirmation, and it will just delete the sheet.
How to Rename Excel worksheet?
Right click on the sheets tab
Excel will give you the menu to choose as below
Click “Rename”
The menu will disappear and the back ground of the sheet name is highlighted
Now you can type the name you desire and Rename the sheet
How to Move or Copy a sheet?
Right Click the Sheets tab
Excel will give you the menu to select “Move or Copy” option
Move and Copy both function are in the same option, so it may be little confusing
If you want to Move a sheet to the end position, just click “Move to end” and then Click “OK”. Do not click any other options
If you want to copy a sheet multiple times in the same workbook then click the check box at the bottom as shown in the below image
You can choose the location you want to copy the sheet. Before which sheet or at the end position or to another excel file or to a new workbook
If you want to Move any sheet or sheets within your current workbook, the simplest way is to drag the sheet to the desired position.
If you want to Move or copy the sheet to another workbook or excel file, do the following.
If you want to copy make sure the check box is clicked, you do not need to check the box if you want to move the sheet
I have 2 excel workbook opened
one is ” All Acc leads.csv”
another one is “Book1” which we are working currently
Excel gives me the option to choose where to move or copy the sheet.
And if you do not want to move this to any existing file and want to move it to a “new book”, excel provides option for that also as shown in the above image