Sheet

You can delete or rename sheets in the workbook. You can also hide sheets or show hidden sheets.

Insert Sheet

  1. Click Edit-Sheet-Insert Sheet.
  2. A new sheet is added to the fight of the last sheet.

Delete Sheet

  1. Select a sheet to delete.
  2. Click Edit-Sheet-Delete Sheet.
  3. A confirmation dialog box appears. Check the message and click Yes.

Move/Copy Sheet

  1. Select the worksheet you want to move or copy.
  2. Click Edit-Sheet-Move/Copy Sheet.
  3. In the Move/Copy Sheet dialog box, select the location you want.
  4. If you want to copy the worksheet, select Copy and then click OK.

Rename Worksheet

  1. Select the worksheet you want to rename.
  2. Click Edit-Sheet-Rename Sheet.
  3. Enter the worksheet name you want to use.

Hide Sheet

  1. Select a worksheet to hide.
  2. 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