Change Workbook structure
Insert a new blank Worksheet
Do one of the following:
-
Click on Insert Worksheet button on the Sheet bar (located the bottom of the left hand corner next to the sheet tabs)
-
Press SHIFT + F11 to insert a new worksheet
Delete Worksheet
-
Select the worksheet needed to be deleted
-
Do one of the following:
-
Go to Home tab > Cells group > click Delete down arrow > select Delete Sheet
-
On the Sheet tab bar, right-click on a selected sheet tab > click Delete
Rename Worksheet
-
Select the worksheet needed to be renamed
-
On the Sheet tab bar, right-click the sheet tab > click Rename Sheet
Copy Worksheet
Copy worksheet within the workbook
Do one of the following:
-
Press CTRL + C and drag the Sheet tab
-
Right click the Sheet name tab > click Move or Copy > do the following in the Move and Copy dialog box:
-
Under Before what section, select the order to place the duplicated sheet
-
Select Create a copy check box
-
Click OK button
Copy worksheet to a new workbook
-
Right click the Sheet name tab > click Move or Copy
-
In the Move and Copy dialog box, do the following:
-
Under To Book section, click the down arrow > select (new book)
-
Select Create a copy check box
Move Worksheet
Do one of the following:
-
Click and drag the Sheet name tab that need to be re-arranged
-
Right click the Sheet name tab > click Move or Copy > do the following in the Move or Copy dialog box:
-
Under Before what section, select the order to place worksheet in
-
Clear Create a copy check box
