How to Use Excel Shortcuts to Add Worksheets

Microsoft Excel Templates for Home or Work
Microsoft Excel Templates for Home or Work. (c) Getty / Hero Images

As with many different options in Microsoft Excel, there are multiple ways of approaching a task. Here, we show you a few different ways to use Excel shortcuts to easily add new worksheets into your existing workbooks. Whether you are more comfortable with the mouse or the keyboard, we have an option to best suit your workflow.

Insert Worksheets with a Keyboard Shortcut

Screenshot of Microsoft Excel, general overview.

Inserting Single Worksheets

There are two different keyboard key combinations for inserting a new worksheet in Excel: Shift + F11 and Alt + Shift + F1. Choose the shortcut that is most comfortable for you to access using your keyboard. As an example, if you wish to insert a worksheet with Shift + F11, you would proceed as follows:

  1. Press and hold the Shift key on the keyboard.
  2. Press and release the F11 key — located above the number row on the keyboard.
  3. Release the Shift key.
  4. A new worksheet will be inserted into the current workbook to the right of all existing worksheets.
  5. To add multiple worksheets continue to press and release the F11 key while holding down the Shift key.

Inserting Multiple Worksheets

To add multiple worksheets at one time using the above keyboard shortcuts, you must first highlight the number of existing worksheet tabs to tell Excel how many new sheets are to be added before applying the keyboard shortcut

The selected worksheet tabs must be adjacent to each other for this method to work.

Selecting multiple sheets can be done with the Shift key and mouse or with one of these keyboard shortcuts: Ctrl + Shift + PgDn selects sheets to the right, and Ctrl + Shift + PgUp selects sheets to the left. Here is an example to insert three new worksheets:

  1. Click on one worksheet tab in the workbook to highlight it.
  2. Press and hold the Ctrl + Shift keys on the keyboard.
  3. Press and release the PgDn key twice to highlight the two sheets to the right — three sheets should now be highlighted.
  4. Follow the instructions above for inserting worksheets using Shift + F11.
  5. Three new worksheets should be added to the workbook to the right of all existing worksheets.

Insert Worksheets with the Sheet Tabs

Screen of Microsoft Excel, adding new sheet via tab.

Inserting Single Worksheets

To add a single worksheet using the mouse, click on the New Sheet icon located next to the sheet tabs at the bottom of the Excel screen, as indicated in the image above. The new sheet is inserted to the right of the currently active sheet.

In Excel 2013, the new sheet icon is the plus sign as shown in the first image above. In Excel 2010 and 2007, the icon is an image of a worksheet but still located next to the sheet tabs at the bottom of the screen.

Inserting Multiple Worksheets

While it is possible to add multiple worksheets simply by clicking multiple times on the new sheet icon, this method can get the job done much more effectively. As before, the new worksheets will be added to the right of all existing worksheets.

  1. Click on one sheet tab to select it.
  2. Press and hold the Shift key on the keyboard.
  3. Click on additional adjacent sheet tabs to highlight them — highlight the same number of sheet tabs as new sheets to be added.
  4. Right-click on one of the selected tabs to open the Insert dialog box.
  5. Click on the Worksheet icon in the dialog box window.
  6. Click OK to add the new sheets and close the dialog box.

Insert Worksheets with the Ribbon Bar

Screen of Microsoft Excel, insert sheets via ribbon bar.

Inserting Single Worksheets

Another method for adding a new worksheet is to use the Insert option located on the Home tab of the ribbon bar in Excel. Those more comfortable with visual controls might find this option the easiest.

  1. Click on the Home tab of the ribbon.
  2. Click on the Insert icon to open the drop-down menu of options.
  3. Click on Insert Sheet to add a new sheet to the left of the active sheet.

Inserting Multiple Worksheets

Alternatively, you can utilize what you had learned from the sheet tab method above to insert multiple worksheets via the ribbon bar.

  1. Click on one sheet tab to select it.
  2. Press and hold the Shift key on the keyboard.
  3. Click on additional adjacent sheet tabs to highlight them — highlight the same number of sheet tabs as new sheets to be added.
  4. Click on the Home tab of the ribbon.
  5. Click on the Insert icon to open the drop-down menu of options.
  6. Click on Insert Sheet to add the new worksheets to the left of the active sheet.