EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources MS Excel Shortcuts Excel Shortcut New Sheet
 

Excel Shortcut New Sheet

Updated June 20, 2023

Excel Shortcut New Sheet

 

 

Excel Shortcut New Sheet (Table of Contents)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • How to Use Excel Shortcut New Sheet?
  • Examples of Excel Shortcut New Sheet

Excel Shortcut New Sheet

When we open an Excel file, we see the 3 worksheets already in every new file by default. The sheets are always in the sequence of Sheet1, Sheet2, and Sheet3, respectively, or in some cases; there is only one sheet as Sheet1. When we change the name of any of the worksheets, and later we add a new worksheet by any method, then the added worksheet would have the named Sheet4. That name would be in sequence with the existing names and worksheets. Even if we delete any worksheet and add a new one, the sequence of the selected worksheet would be the same, considering the deleted worksheet in the count. There are different ways to add a new worksheet to an Excel file.

How to Use Excel Shortcut New Sheet?

There are different ways to open a new sheet in the opened Excel file. The generic procedure for adding a new worksheet in Excel is clicking right on the sheet name tab and selecting the Insert option from the menu list.

 Excel Shortcut New Sheet 1-1

The different processes for adding new sheets are as below;

  1. Manual Process
  2. Through the Home menu ribbon
  3. Through shortcut keys

Examples of Excel Shortcut New Sheet

Lets us discuss the examples of Excel Shortcut New Sheet.

Example #1

In this example, we will see the basic method of adding a new sheet in MS Excel. For this, we will open a blank Excel file as shown below. Currently, in our system, as per the setting, we can only see one worksheet.

Excel Shortcut New Sheet 1-2

Now to add a worksheet in the opened Excel file, click right on the sheet name tab as shown below and select the Insert option.

Excel Shortcut New Sheet 1-3

We will then get a box that will ask for different files which we want to open and insert. Select the Worksheet icon as shown below and click on OK.

Excel Shortcut New Sheet 1-4

A new worksheet will get added in the sequential name of Sheet2, as shown below.

new worksheet

Example #2

This is another shortcut method to add a new sheet in an Excel file. To do this, open an Excel worksheet again, and look for a section at the bottom left with the sheet names and a PLUS option, as seen below.

Now click on that PLUS button.

sheet 3

This will simply add a new worksheet as per the current naming sequence or previously added file names. Here, we already had Sheet1 and Sheet2, so we would get Sheet3, as shown below.

sheet 3-1

If we change the name of a worksheet into different names and again we try to add new sheets, then we will see the new worksheet will be added with the same default name. For testing, we have changed the names of the sheets to Test1, Test2, and Test3, as shown below. Now click on the PLUS tab and see the name of the worksheet which will get added.

test 4

We will see the newly added sheet name is by default named Sheet4 in the sequence of a number of sheets that we added recently.

sheet 4

Example #3

To add a new worksheet in an Excel file, we have a shortcut key, which would simply add a new worksheet to opened Excel file. To insert a new sheet using the shortcut key, press SHIFT + F11 together. This would add a new sheet in the sequential name of worksheets that are already opened.

sheet 5

Example #4

We have seen most of the possible ways to add new sheets in Excel. But every function or operation which we could be performed by shortcut keys and right-clicking the menu list could also be performed by using the options available in the Menu ribbon tab. To insert a new sheet using the menu option, first, go to the Home menu ribbon, and under the cells section, we have the Insert option under the same Home menu ribbon as shown below.

home tab

From the dropdown menu list of the Insert option, we select Insert Sheet as shown below.

insert sheet

Once we select this Insert Sheet option, a new worksheet will get added, as shown below in the name of Sheet6.

sheet 6

Example #5

There is another way to add a new worksheet. For this, press and hold the CTRL key and drag any added worksheet, as shown below.

sheet 7

Once we release the CTRL key, the selected sheet will get copied along with data with duplicate names of the same, as shown below.

Pros Of Excel Shortcut New Sheet

  • All the methods and procedures shown in the above examples are simple to execute.
  • There is no limit on restrictions on adding new worksheets by any method.
  • We can change the setting to see the default sheet names and default sheet count when we open a worksheet or a workbook.

Things To Remember

  • Mostly the sheet name is in the sequential count as per the sheet added previously.
  • If a worksheet is deleted and a new one is added after that, the newly added worksheet will maintain the numbering sequence of the deleted worksheet rather than align with the existing worksheets. For example, we have 3 worksheets, and we delete 3rd. Adding a new worksheet after that will be named Sheet 4.
  • We can even change the default name of any worksheet from Sheet 1 to any other name.
  • Dragging the already existing sheet will create a new copy of the same worksheet with data available under it.

Recommended Articles

We hope that this EDUCBA information on “Excel Shortcut New Sheet” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

  1. Copy Excel Sheet
  2. Worksheets in Excel
  3. How to Unhide All Sheets in Excel?
  4. Protect Sheet in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW