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 other latest versions, manytimes, we require 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 Shortcut 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 of which you want to add a new sheet.
- After that, just press the keyboard shortcut keys “Shift + F11”.
- Or you can also use “Alt + Shift + F1” and you will get the new sheet added.