The steps in this guide are going to show you how to use a keyboard shortcut to create a new worksheet in Microsoft Excel.
- An Excel workbook is the Excel file itself, while an Excel worksheet is a single spreadsheet within that workbook.
- You can switch between worksheets in Excel by clicking the file tabs at the bottom of the window.
The Excel new sheet shortcut is Shift + F11.
Alternatively you can create a new Excel worksheet with another shortcut, which is Alt + Shift + F1.
So if you want to create a new worksheet in Excel using only keyboard shortcuts, then you would complete the following steps:
- Open the Excel workbook.
- Press Shift + F11 on your keyboard (or press Alt + Shift + F1.)
If you would like to create a new worksheet in Excel without using a keyboard shortcut, then simply click the + button at the bottom of the window.
Note that worksheets created with the keyboard shortcut or by clicking the + sign will use the naming convention of SheetX, where X is 1 + the current number of worksheets.
To rename a worksheet, right-click on the worksheet tab at the bottom of the window, then choose the Rename option.
Note that there are other options on that shortcut menu, including Delete, Hide, and Tab Color which allow you to further customize your worksheets.
Find out how to make your gridlines darker in Excel if you are having trouble viewing them on your screen.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.