Insert Single Worksheets with Keyboard Shortcuts
There are two different keyboard key combinations you can use to insert a new worksheet in Excel: Shift+F11 and Alt+Shift+F1. Choose the keyboard shortcut that’s most comfortable for you to access. To insert a worksheet using Shift+F11, follow these steps:
Insert Multiple Worksheets With Keyboard Shortcuts
To add multiple worksheets at one time using the above keyboard shortcuts, highlight the number of existing worksheet tabs to tell Excel how many new sheets are to be added before applying the keyboard shortcut. To select multiple sheets, use the Shift key and your mouse or use one of these keyboard shortcuts:
Ctrl+Shift+PgDn selects sheets to the right.Ctrl+Shift+PgUp selects sheets to the left.
Here’s an example of how to insert three new worksheets:
Insert Single Worksheets With the Sheet Tabs
To add a single worksheet using the mouse, select the Plus (+) icon next to the sheet tabs at the bottom of the Excel screen. The new sheet is inserted to the right of the currently active sheet.
Insert Multiple Worksheets With the Sheet Tabs
While it’s possible to add multiple worksheets by selecting New Sheet several times, there’s another way to use a dialog box. With this method, the new worksheets are added to the right of all existing worksheets. To use the Insert dialog box to add multiple worksheets:
Insert Single Worksheets With the Ribbon Bar
Another method to add a new worksheet is to use the Insert option located on the Home tab of the ribbon bar in Excel. If you’re more comfortable with visual controls, you may find this option the easiest. Follow these steps to insert a single worksheet using the Insert command:
Insert Multiple Worksheets with the Ribbon Bar
It’s also possible to insert multiple worksheets using the Insert command on the ribbon bar. Here’s how:
