Add New Sheet (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

In Excel, when we open the new workbook, we always find three worksheets in the older Excel versions (2013 and 2016) and only one sheet in Excel 2019 and the other latest versions.

Many times, we are required to add a new worksheet in the current workbook to capture any additional data values, control tables, and so on.

For this, we can use the keyboard shortcut to add a new sheet, and a new sheet will always be added to the left of the current/selected sheet.

Keyboard Shortcuts to Add New Sheet in the Excel

We have defined two keyboard shortcuts below for you to choose which suits you.

Shift + F11

Alt + Shift + F1

Other Methods to Add Worksheets in Excel

Steps to Add Row(s) Using Keyboard Shortcut

  1. First of all, open the workbook.
  2. Now go to the sheet to the left to which you want to add a new sheet.
  3. After that, just press the keyboard shortcut keys Shift + F11.
  4. You can also use Alt + Shift + F1 and you will get the new sheet added.
Last Updated: January 10, 2024