Working with spreadsheets

Excel 2016
This tip describes shortcut keys that can be useful for adding, deleting, moving, or coping spreadsheets. See also how to change the color for worksheet tabs, making the spreadsheet very hidden.

Making worksheet active

At any given time, only one workbook is active, and only one sheet is active in the active workbook. To activate a different sheet, click the sheet tab located at the bottom of the workbook window. You also can use the following shortcut keys to activate a different sheet:

  • Ctrl+PgUp: Activates the previous sheet if one exists
  • Ctrl+PgDn: Activates the next sheet if one exists

Adding a new worksheet

There are several ways to add a new worksheet to a workbook:

  • To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen:
    Insert Worksheet in Excel 365
  • To insert a new worksheet before an existing worksheet, select that worksheet, and then on the Home tab, in the Cells group, click Insert, and then click Insert Sheet:
    Insert Worksheet in the ribbon Excel 365
  • Press Shift+F11 or Alt+Shift+F1.
  • Right-click the sheet tab, choose the Insert... command from the shortcut menu, select Worksheet from the Insert dialog box, and then click OK:
Insert Worksheet right-click popup in Excel 365

When you add a new worksheet to the workbook, Excel inserts a new worksheet before the active worksheet, and the new worksheet becomes an active worksheet.

To insert more than one worksheet at a time, hold down the Shift key and select the range of worksheet tabs. When you run the command to insert a worksheet, Excel will add as many worksheets as many worksheet tabs you selected before running the command.

Rearranging worksheets

To rearrange the order of worksheets in the workbook, do one of the following:

  • Right-click the sheet tab and choose Move or Copy... in the popup menu:
    Move or Copy in popup menu Excel 365

    In the Move or Copy dialog box, move or copy a worksheet in the same or another workbook:

    Move or Copy dialog box in Excel 365
  • To move a worksheet, click the worksheet tab and drag it to the desired location. When you drag, the mouse pointer changes to a small sheet, and a small arrow guide you:
    Move a spreadsheet in Excel 365

    Note: To move the worksheet to a different workbook, the second workbook must be open but not maximized.

  • To copy the worksheet, click the worksheet tab, and press Ctrl while dragging the tab to the desired location. When you drag, the mouse pointer changes to a small sheet with a plus sign on it:
    Copy a spreadsheet in Excel 365

    Note: To copy the worksheet to a different workbook, the second workbook must be open and not maximized.

Notes:

  1. To move or copy multiple sheets, group them, then take steps for grouped sheets as for the one sheet.
  2. If you move or copy the worksheet to the workbook that already has a sheet with the same name, Excel changes the name automatically to make it unique. For example, Sheet1 becomes Sheet1 (2).

Deleting a worksheet

To remove the worksheet in the workbook with more than one spreadsheet, or to get rid of an empty worksheet in a workbook, do one of the following:

  • Right-click the sheet tab you want to remove and choose Delete from the shortcut menu:
    Delete tab in popup menu Excel 365
  • Activate the unwanted worksheet, then on the Home tab, in the Cells group, click the Delete button, then select Delete Sheet:
    Delete Sheet in the ribbon Excel 365

    If the worksheet is not empty, Excel asks you to confirm that you want to delete the sheet:

    Delete sheet message in Excel 365

Notes:

  1. To delete multiple sheets, group them, then delete grouped sheets as one sheet.
  2. Deleting a worksheet is one of the few operations in Excel that can't be undone.

See also this tip in French: 3 raccourcis clavier pour la feuille de calcul.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.