You can delete or rename sheets in the workbook. You can also hide sheets or show hidden sheets.
Insert Sheet
- Click Edit-Sheet-Insert Sheet.
- A new sheet is added to the fight of the last sheet.
Delete Sheet
- Select a sheet to delete.
- Click Edit-Sheet-Delete Sheet.
- A confirmation dialog box appears. Check the message and click Yes.
Move/Copy Sheet
- Select the worksheet you want to move or copy.
- Click Edit-Sheet-Move/Copy Sheet.
- In the Move/Copy Sheet dialog box, select the location you want.
- If you want to copy the worksheet, select Copy and then click OK.
Rename Worksheet
- Select the worksheet you want to rename.
- Click Edit-Sheet-Rename Sheet.
- Enter the worksheet name you want to use.
Hide Sheet
- Select a worksheet to hide.
- Click Edit-Sheet-Hide Sheet.
Click Edit-Sheet-Unhide Sheet to show all hidden sheets.
Note
Sheet Context Menu
Right-click a sheet tab to use context menu.
Move Sheet with Mouse Drag
You can move a worksheet by dragging it. Drag the worksheet you want to move and drop it to the location you want.
Submenu of Sheet
Sheet | Shortcuts | Description |
---|---|---|
Insert Sheet | Shift+F11 | Insert a sheet in the worksheet. |
Delete Sheet | - | Delete the selected sheet. |
Move/Copy Sheet | - | Move the selected sheet to another location or copy it. |
Rename Sheet | - | Rename the selected sheet. |
Hide Sheet | - | Hide the selected sheet. |
Show Sheet | - | Show the hidden sheet./td |
Tab Color | - | Specify the tab color you want in the color palette. |