Using Excel Shortcuts to Add Worksheets

Contents
  1. Save time with these handy keyboard and mouse shortcuts
  2. Insert individual sheets with keyboard shortcuts
  3. Insert multiple sheets with keyboard shortcuts
  4. Insert individual sheets with sheet tabs
  5. Insert multiple sheets with sheet tabs
  6. Insert individual sheets with the ribbon
  7. Insert multiple sheets with the ribbon

Save time with these handy keyboard and mouse shortcuts

To quickly add new sheets to your Excel workbooks, use the shortcut. Whether you’re more comfortable using a mouse or a keyboard, there’s an option to best suit your workflow.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010, and 2007.

Insert individual sheets with keyboard shortcuts

You can use two different keyboard shortcuts to insert a new sheet in Excel: Shift F11 And alt Shift F1. Choose the most useful shortcut.

To paste a sheet with Shift + F11, do the following:

  1. Press and hold a key Shift on keyboard.

  2. Press and release the button F11

  3. Release the key Shift † The new sheet is inserted into the current workbook, to the left of all existing sheets.

  4. To add multiple sheets, click Shift F11 for each additional sheet.

Insert multiple sheets with keyboard shortcuts

To add multiple sheets at once using the above keyboard shortcuts, mark the number of existing sheet tabs to tell Excel how many new sheets to add before applying the keyboard shortcut.

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

To select multiple sheets, use the Shift key and mouse, or one of the following keyboard shortcuts:

  • ctrl Shift PgDn selects sheets on the right.
  • ctrl Shift pgup selects sheets on the left.

Here’s an example of how to insert three new sheets:

  1. Select a sheet tab in the workbook to highlight it.

  2. Press and hold ctrl Shift

  3. Press the button and release PgDn twice to select the two sheets on the right. Three blades are marked.

  4. Click Shift F11 to insert new worksheets (see instructions above if you need help). To the left of the existing worksheets, three new worksheets have been added to the workbook.

Insert individual sheets with sheet tabs

To add one sheet with the mouse, select new leaf † You’ll find it next to the sheet tabs at the bottom of the Excel screen. The new sheet is inserted to the right of the currently active sheet.

In Excel 2010 and 2007, the New Sheet icon is an image of the sheet, but it’s still next to the sheet tabs at the bottom of the screen.

Insert multiple sheets with sheet tabs

While it is possible to add multiple sheets by selecting “New Sheet” multiple times, there is another way to use the dialog box. This method adds new worksheets to the right of all existing worksheets.

To use the Insert dialog box to add multiple sheets:

  1. Select sheet tab to mark it.

  2. Press and hold a key Shift

  3. Select additional adjacent sheet tabs to highlight them. Mark as many tabs as there are new sheets you want to add.

  4. Right click on the last selected sheet tab and select Insert to open the Paste dialog box.

  5. Select worksheet in the Insert dialog box.

  6. Select Okay to add new sheets and close the dialog.

Insert individual sheets with the ribbon

Another way to add a new sheet is to use the Insert option on the Home tab of the ribbon bar in Excel. If you are more comfortable using visual controls, this may be the easiest option.

Follow these steps to insert a single sheet using the Paste command:

  1. Select tab At home

  2. Select Insert drop-down arrow to open the drop-down menu of options.

  3. Select Insert sheet to add a new sheet to the left of the active sheet.

Insert multiple sheets with the ribbon

You can also insert multiple sheets using the Paste command on the ribbon bar.

Here’s how:

  1. Select sheet tab to mark it.

  2. Press and hold a key Shift

  3. Choose extra adjacent sheet tabs to mark them. Mark as many tabs as there are new sheets you want to add.

  4. Select Home

  5. Select Insert drop-down arrow to open the drop-down menu of options.

  6. Select Insert sheet to add new worksheets to the left side of the active worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *