Press Shift + F11. Excel inserts a new blank worksheet to the left of the sheet you are on and makes it the active sheet. Alt + Shift + F1 does the same thing.
Because the new sheet lands on the left, first go to the sheet that should end up to the right of the new one. To add a sheet to the right of the current one instead, click the + (New sheet) button next to the sheet tabs.
To add several sheets, press F4 after Shift + F11 to repeat the insert, one sheet per press. Or hold Shift, click as many existing sheet tabs as the number of sheets you want, and use Home → Insert → Insert Sheet (key tips Alt, H, I, S).
New workbooks in Excel 2013 and later start with one sheet; Excel 2010 and earlier started with three. To change the default, go to File → Options → General and set Include this many sheets.
If Shift + F11 does nothing, check two things. On many laptops the function row controls volume or brightness, so you need Fn + Shift + F11. And if Insert Sheet is greyed out, the workbook structure is protected; turn it off with Review → Protect Workbook, entering the password if one was set.
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
Steps to Add Row(s) Using Keyboard Shortcut
- First of all, open the workbook.
- Now go to the sheet to the left to which you want to add a new sheet.
- After that, just press the keyboard shortcut keys Shift + F11.
- You can also use Alt + Shift + F1 and you will get the new sheet added.