WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel New Sheet Shortcut

Excel New Sheet Shortcut

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

New Sheet Shortcut Keys in Excel

When you are working, we may need to quickly insert a new worksheet to enter something very important, so in those cases, our shortcut key is important to quickly have a new worksheet in place. Can we include all the information or data in a single worksheet itself? Answers are almost 99.99% of the time “No” only because data may contain multiple information that needs to be stored in multiple worksheets of the workbook. So keeping in mind the importance of having a new sheet. In this article, we will teach you the shortcut keys to insert new sheets in excel.

How to Insert New Excel Worksheet?

I don’t know whether you have noticed or not; by default, when we open the new workbook, we will have 3 worksheets in place in the name of “Sheet1, Sheet2, and Sheet3”.

Excel New Sheet Shortcut Example 1

However, we can modify this default setting, and that is a different topic altogether; you can refer to our article on “Insert New Worksheet” to have detailed information about it; let’s get back to this topic, “Excel Shortcut New Sheet.”

Inserting a new worksheet is often required while working in excel, so we can insert excel worksheet in excel using multiple ways.

You can download this New Sheet Shortcut Excel Template here – New Sheet Shortcut Excel Template

#1 – New Excel Worksheet Shortcut Using Manual Process

Step 1: To insert a new worksheet, we need to right-click on any of the existing worksheets.

Example 1.1

Step 2: When you right-click on the worksheet, we can see the option “Insert,” and if you click on this, it will open below dialogue box for us.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Excel New Sheet Shortcut Example 1.2

Step 3: From the above, choose “Worksheet,” and we will have the new worksheet in place.

Example 1.3

One thing we have noticed here is when the new sheet is inserted, it will push the existing worksheet to the right, and the new sheet becomes the active sheet. There is also another manual way of inserting a new worksheet, and that will be much easier than the above method.

Step 4:Go to the HOME tab in the ribbon and choose the “Insert” button under the HOME tab.

Excel New Sheet Shortcut Example 1.4

Step 5:Now select Insert Sheet option. This will insert the new worksheet by pushing the active worksheet to the right side and acquires the position of the active sheet.

Example 1.5

#2 – Insert New Excel Sheet by Using Shortcut Key

Manual steps are always the time-consuming and frustrating thing to do, but using shortcut keys, we can quickly insert new worksheets. Below is the shortcut key to insert a new sheet in the excel workbook.

Shortcut key to Insert New Sheet:

Excel New Sheet Shortcut Example 1.14

You need to hold the SHIFT key and press the F11 function key to insert a new sheet in the existing excel workbook.

  • If you press the F11 key by holding the SHIFT key, it will keep inserting the new worksheets in the serial order of the worksheet. For example, look at the below existing worksheet in excel.

Excel New Sheet Shortcut Example 1.6

We have worksheets named “Sheet 1, Sheet 2, Sheet 3, and Sheet 4” and the active sheet is “Sheet 1”.

  • Now I will press “Shift + F11” and see the position of the new worksheet and its name.

Example 1.7

The new worksheet position is to the left of the active sheet, and the new sheet name is incremental of the previous worksheet name.

  • For example, the previous worksheet name was “Sheet 4,” and when the new worksheet was inserted, it becomes “Sheet 5”.

Excel New Sheet Shortcut Example 1.8

  • Now I will delete the worksheet “Sheet 5”.

Example 1.9

  • Now again, I will insert the new sheet by using the shortcut key “Shift + F11”.

Excel New Sheet Shortcut Example 1.10.0

Now, look at the worksheet name; instead of getting “Sheet 5” as the new worksheet name, we have got “Sheet 6”. This is because we have already inserted Sheet 5 and deleted, so excel keeps count of how many worksheets are inserted.

Replica of Existing Sheet as New Sheet by Using Shortcut

In many cases, we may need to create a new worksheet to have the existing data in the new worksheet. If you are following the process of inserting a new worksheet then copying the data to a new worksheet, we will show you new techniques now.

  • For example, look at the below data in excel.

Example 1.11

  • In Sheet 2, we have the below data. Now we need the same data in a new worksheet as well.

Excel New Sheet Shortcut Example 1.12

  • So the new technique holds the Ctrl key and drags the worksheet to the right side. When you are dragging, we will see a small “PLUS” icon appears.

Replica of Existing Sheet

  • The moment you place your cursor outside the sheet release control key and release mouse holding, this will create a new worksheet.

Example 1.13

Like this, we can create a new sheet in excel using shortcut keys.

Things to Remember Here

  • SHIFT + F11 is the shortcut key to insert a new worksheet.
  • Ctrl + Drag will create the replica of the existing worksheet, and the only changes are sheet name.

Recommended Articles

This has been a guide to excel new sheet shortcut keys. Here we discuss 2 ways to insert a new excel worksheet using the shortcut key (Shift + 11) along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Excel Shortcut for Insert Row
  • Excel Shortcut For Save As
  • Excel Shortcut for Delete Row
  • Excel Shortcut for Filter
5 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download New Sheet Shortcut Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More