3 Shortcut keys for worksheet

Excel 365 2013 2010 2007 2003
This tip describes shortcut keys that can be useful.

Making a worksheet the active sheet

At any given time, one workbook is the active workbook, and one sheet is the active sheet in the active workbook. To activate a different sheet, click its 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

The following 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 2016
  • 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:
    Cells in Excel 2016
  • Press Shift+F11 or Alt+Shift+F1.
  • Right-click a sheet tab, choose the Insert... command from the shortcut menu, select Worksheet from the Insert dialog box, and then click OK.

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

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

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

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more