Software & Apps MS Office How to Use Excel Shortcuts to Add Worksheets Save time with these handy keyboard and mouse shortcuts by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on December 02, 2020 The Ultimate Guide to Keyboard Shortcuts The Ultimate Guide to Keyboard Shortcuts Introduction Windows Timesavers The Best Windows 10 Keyboard Shortcuts Essential Keyboard Shortcuts for Better Productivity How to Use the Shortcut Alt + Underline Shortcut to Create New Folders Essential Shortcuts for iTunes Mac, iOS & iPad Quick Tricks The Best Mac Shortcuts Keyboard Shortcuts for Finder Mac Startup Keyboard Shortcuts 18 Shortcuts for Apple's iOS Shortcuts App iPad Keyboard Tips and Smart Keyboard Shortcuts Android & iPhone Shortcuts The Best Android Shortcuts You Should Be Using Create and Use iPhone X Shortcuts Email Shortcuts The 30 Best Gmail Keyboard Shortcuts for 2020 How to Use Yahoo Mail Keyboard Shortcuts The Complete Apple Mail Shortcut List Shortcuts in iOS Mail Delete Shortcut Keys for Popular Email Programs How to Use Outlook.com Keyboard Shortcuts Create Text Snippets With Shortcuts in Mac OS X Mail Online & Browser Shortcuts Top 36 Shortcuts for Edge and IE 11 Keyboard Shortcuts: Google Chrome for Windows Create Web Page Shortcuts in Chrome for Windows Control Safari Windows With Keyboard Shortcuts Shortcuts for Safari Toolbars Shortcuts for Safari on OS X & Sierra Excel Shortcuts The 23 Best Excel Shortcuts Shortcut Excel's Fill Down Command Shortcut the Current Date/Time Formatting Numbers Adding Worksheets Shortcut to Saving Your Work Creating a Chart MAX Function Shortcut More Office Shortcuts Top 10 Microsoft Word Shortcuts The 5 Best Hidden Word Shortcuts Add Shortcut Keys to AutoText Entries Uppercase Shortcut Key How to Reset Keyboard Shortcuts in Word Shortcut to Speed Up PowerPoint Presentations Other Useful Shortcuts The Best Google Docs Shortcuts 18 Shortcuts for Linux Mint 18 Cinnamon Changing Linux Mint Cinnamon Shortcuts Fedora GNOME Keyboard Shortcuts Maya Keyboard Shortcuts Create or Reassign Keyboard Shortcuts in MS Office Useful Keyboard Shortcuts for Photoshop CC Time-Saving Fill Tool Shortcuts in Photoshop The 5 Most Useful GIMP Keyboard Shortcuts How to Use the GIMP Keyboard Shortcut Editor Shortcuts to Type a Tilde Mark Tweet Share Email When you want to quickly add new worksheets to your Excel workbooks, use a shortcut. Whether you are more comfortable with the mouse or the keyboard, there's an option to best suit your workflow. Instructions in this article apply to Excel 2019, 2016, 2013, 2010, and 2007. 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. Lifewire / Kyle Fewel To insert a worksheet using Shift+F11, follow these steps: Press and hold the Shift key on the keyboard. Press and release the F11 key. Release the Shift key. A new worksheet is inserted into the current workbook to the left of all existing worksheets. To add multiple worksheets, press Shift+F11 for each additional worksheet. 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. The selected worksheet tabs must be adjacent to each other for this method to work. 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: Select one worksheet tab in the workbook to highlight it. Press and hold Ctrl+Shift. Press and release the PgDn key twice to highlight the two sheets to the right. Three sheets are highlighted. Press Shift+F11 to insert the new worksheets (see the instructions above if you need help). Three new worksheets are added to the workbook to the left of the existing 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. In Excel 2010 and 2007, the New Sheet icon is an image of a worksheet but it's still located next to the sheet tabs at the bottom of the screen. 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: Select a sheet tab to highlight it. Press and hold the CTRL key. Select additional adjacent sheet tabs to highlight them. Highlight the same number of sheet tabs as the number of new sheets you want to add. Right-click on the last sheet tab you selected and select Insert to open the Insert dialog box. Select Worksheet in the Insert dialog box, then select OK to add the new sheets and close the dialog box. 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: Select the Home tab. Select the Insert drop-down arrow to open the drop-down menu of options. Select Insert Sheet to add a new sheet to the left of the active sheet. 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: Select a sheet tab to highlight it. Press and hold the CTRL key. Select additional adjacent sheet tabs to highlight them. Highlight the same number of sheet tabs as the number of new sheets you want to add. Select the Home tab. Select the Insert drop-down arrow to open the drop-down menu of options. Select Insert Sheet to add the new worksheets to the left of the active sheet.