Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft > How to Insert a New Worksheet in Excel? 5 Easy Ways

How to Insert a New Worksheet in Excel? 5 Easy Ways

  • Facebook
  • Twitter
  • YouTube

(Note: This guide on how to insert a new worksheet in Excel is suitable for all Excel versions including Office 365

In Excel, you can add, store, retrieve, and perform operations on a variety of data. These data are stored in Excel files, which are technically called Excel Workbooks. To minimize the handling of multiple workbooks to store data, the concept of worksheets was introduced. 

A Worksheet is a space in a workbook where you can store data. With the help of multiple worksheets, you can store different types of data in a single workbook. This will help you to retrieve and share data easily.

For better understanding, if you think of an Excel workbook as a book, then the worksheets are the pages in them.

When you open an Excel workbook, usually, only one worksheet will be available by default. If you want more than one worksheet and want to insert them, what will you do?

In this article, I will tell you how to insert a new worksheet in Excel in 5 easy ways. 

You’ll Learn:

  • 5 Ways to Insert a New Worksheet in Excel
    • By Clicking the + Icon
    • By Right-Clicking on the Worksheet
    • Using the Keyboard Shortcut
    • Using the Home Main Menu
    • Using VBA Macros
  • Change the Default Number of Sheets When You Open

Related Reads:

How to Insert Image in Excel? 3 Easy Ways

How to Insert Radio Buttons in Excel? A Step-by-Step Guide

How to Insert PDF in Excel? 5 Easy Ways

5 Ways to Insert a New Worksheet in Excel

There are a couple of methods to insert a new worksheet in Excel in an easy way. 

By Clicking the + Icon

This is an easy method to add a new worksheet with just a click. 

When you open an Excel workbook, you can see the current worksheet you’re in and the total number of worksheets in the particular workbook towards the bottom left corner of the Excel window.

  • To insert a new worksheet, click on the (+) icon next to the worksheet name.
How to Insert a New Worksheet in Excel using + icon
How to Insert a New Worksheet in Excel using + icon
  • This inserts a new worksheet towards the right of the existing worksheet. 

Once you have inserted a sufficient number of worksheets, you can use the arrow buttons to navigate between the hidden worksheets and view them. 

By Right-Clicking on the Worksheet

There is another way to insert a new worksheet in Excel from the worksheet tab.  

  • Right-click on any of the existing worksheets and select Insert.
Right-click and select Insert
Right-click and select Insert
  • This opens the Insert dialog box. 
  • Under the General tab, select Worksheet and click OK.
Click OK
Click OK
  • This inserts a new Worksheet next to the current worksheet.

Though this method takes a couple of additional steps, this method gives you the option to choose between the types of worksheets or worksheet templates. 

Using the Keyboard Shortcut

For almost every operation in Excel, there is a keyboard shortcut that enables you to perform them with ease. Even to insert a new worksheet in Excel, the shortcut keys prove to be an easy, quick, and efficient way.

  • To insert a new worksheet in Excel, hold the Shift key and press the F11 function key (Shift+F11). To use the function key in some keyboards, you will have to press the function key and then the F11 key. 
  • This instantly inserts the worksheet towards the left of the existing worksheet.
  • There is another way to insert a new worksheet in Excel. In this method, hold the Alt and Shift keys and press the F1 key (Alt+Shift+F1). 

Note: You can use these methods to insert multiple worksheets at the same time quickly and efficiently. 

Suggested Reads:

How to Insert a Hyperlink in Excel? 3 Easy Ways

How to Insert Bullet Points in Excel? 5 Easy Methods

How to Insert a Page Break in Excel? (3 Simple Steps)

Using the Home Main Menu

Another way to insert a new worksheet in Excel is from the Home main menu. 

  • Navigate to the Home main menu in the Excel ribbons. 
  • Under the Cells section, click on the dropdown from Insert and select the Insert Sheet.
How to insert a new worksheet in Excel using Insert
How to insert a new worksheet in Excel using Insert

This immediately inserts a new worksheet next to the existing worksheet. 

Using VBA Macros

Using the above-mentioned methods, we can insert one worksheet at a time. However, if you want to insert multiple worksheets (10 or 20) in a single go, you can use a VBA code. 

  • To use the VBA code to insert a new worksheet, first, enable the Developer tab. Navigate to File and click on Options. In the Excel Options dialog box, click on Customize Ribbon. 
  • In the Customize the ribbon section, check the checkbox for the Developer tab and click OK. This enables the Developer option in the main menu.
  • In the Developer tab, click on Visual Basic. 
Enable Developer and select Visual Basic
Enable Developer and select Visual Basic
  • The Microsoft Visual Basic for Application window opens. 
  • Click on the View main menu and select Immediate Window. 
Select Immediate Window
Select Immediate Window
  • In the Immediate window, enter the VBA code Sheets.Add Count:=10, where 10 denotes the number of worksheets you want to insert. In case you want to add 20 worksheets, change the code to Sheets.Add Count:=20.
Enter the code
Enter the code

Press Enter. You can see the worksheets added in the Project pane on the left. 

  •  Now, close the VBA window. 

In the Excel window, you can see the set number of worksheets inserted. This method is preferred when you need to insert a bulk of worksheets and prevents any error.

Change the Default Number of Sheets When You Open

When you open previous versions of Excel (Excel 2013 or Excel 2016), the workbook opens with three worksheets by default. However, in later versions, only one worksheet is available by default when you open the workbook. 

But, Excel offers you an option to set the default number of worksheets when you open it.

  • To set the default number of worksheets, open any Excel workbook.
  • Navigate to the File tab and click on Options. 
  • Click on the General tab. 
  • Scroll down to the When creating new workbooks section. In the Include this many sheets section, either enter the number or use the up and down buttons to set the number of worksheets.
  • Click OK.
Change the default number of sheets
Change the default number of sheets

Now, every time you open a new Excel workbook, three worksheets open by default. 

Also Read:

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Calculate IRR in Excel? 3 Important Functions

How to Calculate Time in Excel? 2 Distinct Types

Frequently Asked Questions

What is the shortcut key to insert a new worksheet in Excel?

The shortcut key to insert a new worksheet in Excel is by pressing the Shift + F11 function key. Another way to insert a new worksheet is by pressing the Alt +Shift +F1 key.

What is the easiest way to insert a new worksheet in Excel?

To insert a new worksheet, click on the (+) icon you find towards the bottom left of the Excel window above the accessibility status bar. 

How to add a new worksheet using Excel VBA?

Click on the Developer tab and click on the Visual Basic button. In the Visual Basic window, click on View and select Immediate Window. In the Immediate window, enter the code Sheets.Add Count:=10, where 10 denotes the number of sheets you want to insert.

Closing Thoughts

Inserting a new worksheet in Excel can help you keep all your data in one place. This, in turn, makes data handling more efficient and organized.

In this article, we saw how to insert a new worksheet in Excel in 5 easy ways. Choose the method that suits your purpose the best. 

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

NetSuite vs QuickBooks: Ultimate Guide

Start Co-Authoring Excel Workbooks in 6 Easy Steps

Top 10 Essential Microsoft Project Templates for Project Management

How to Customize Reports in QuickBooks 2019

Creating Your First Project in Microsoft Project

How to Use Backstage View in Microsoft Publisher 2013

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)