Sheet

Modified on Wed, Nov 26 at 8:32 PM

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

SheetShortcutsDescription
Insert SheetShift+F11Insert 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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article