3 Shortcut keys for worksheet

In this tip describes shortcut keys which can 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, just 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 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.