Add New Sheet in Excel (Shortcut)

In the newer versions of Excel, when you open a new workbook, there is only one worksheet by default (there used to be three sheets in earlier versions).

This means that most Excel users would often have a need to insert one or more new sheets in the workbook.

In this tutorial, I will give you the shortcut to add a new sheet in Excel

Shortcut to Add New Sheet in Excel

Below is the shortcut to Add New Sheet in Excel

Shift + F11 (recommended)

or

ALT + Shift + F1

How to Use the Keyboard Shortcut to Add New Sheet in Excel

Below are the steps to use the above keyboard shortcut:

  1. Activate the workbook in which you want to insert a new sheet
  2. Use the shortcut SHIFT + F11 (hold the SHIFT key and then press the F11 key)

Using the above shortcut once would insert one new sheet in your workbook.

If you want to insert more worksheets, you need to use this shortcut multiple times. So if you hold the SHIFT key and then press the F11 key twice, it is going to insert two new worksheets in your workbook.

Advance Excel Tip: Once you have inserted one worksheet using the shortcut SHIFT + F11, you can continue to add more sheets by using the F4 key (which simply repeats your last action)

Important Things to Know About Add New Sheet in Excel:

  • The new sheet would always be added to the left of the active sheet (in the worksheet tabs order)
  • The maximum number of sheets that can be inserted in Excel is data mined by your computer’s RAM. In general, it’s a good practice to remove any worksheets that you do not need and keep the worksheets to a minimum to improve the performance of your Excel file

Other Excel shortcuts you may also like:

Other Excel Tutorials You May Also Like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment