Sheet
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. |
See Also
Undo, Redo