DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Windows Computer
    • Fundamentals
  • Digital Marketing
    • WordPress
    • Online Tools
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
  • HTML Sitemap
  • Contact us
Menu

6 Ways to Insert New Worksheet In Microsoft Excel – 2022

Posted on 27/04/201923/08/2023 by DigiRuns

In an Excel spreadsheet, there are several options to insert “New Worksheet”. These are either keyboard shortcuts or other options from the ribbon. In this article, six different ways are provided below to insert a new worksheet in Excel.

Table of Contents

1. Click New Sheet Tab Button
2. Shortcut Key to Insert a New Worksheet
3. Shortcut Key to Insert New Worksheet in Excel
Method-4
Method-5
What are the shortcut keys to insert a new worksheet in Excel?
How can I insert a new worksheet in Excel using the keyboard shortcut?
Is there a way to insert multiple worksheets at once?
How do I insert a new worksheet next to an existing one?
What’s the method to add a new worksheet using the Ribbon menu?

1. Click New Sheet Tab Button

Click on the “New Sheet” button, which appears at the right of the existing worksheet tabs, as given in the picture below.

Adding a new sheet tab
Adding a new sheet tab

2. Shortcut Key to Insert a New Worksheet

To insert a New Worksheet in Excel by using the shortcut keys, Press Shift+F11 or Alt+Shift+F1.

3. Shortcut Key to Insert New Worksheet in Excel

To insert more worksheets at a time, keep holding down the Shift key, then press F11 as many new worksheets as you want, or keep pressing and holding down Alt + Shift key, and press then F1 as many sheets as you want.

Right-click on a sheet tab where you want to insert the new worksheet

Then click on “Insert” as in the picture below.

5-Ways-to-Insert-New-Worksheet-In-MS-Excel
Inserting new worksheet in excel by using the right-click

After that,  select the “Worksheet” under “General”, and then click ok.

Insert New Worksheet In MS-Excel by right click
Inserting New Worksheet In MS Excel by right-clicking the sheet tab

Method-4

Go to the Home tab

Then click on the drop-down arrow of the Insert in the Cells group

Afterwards, click the “Insert sheet”.

Inserting a new worksheet
Inserting a new worksheet

Method-5

  1. Press Alt + H→I→S
Insert new worksheet
Another way to insert a new sheet is by pressing Alt + H + I + S

The ways to insert new worksheets in MS Excel are beneficial. So it would be best if you learned these to become a master.

Frequently Asked Questions:

What are the shortcut keys to insert a new worksheet in Excel?

To insert more worksheets at a time, keep holding down the Shift key, then press F11 for as many new worksheets as you want, or keep pressing and holding down the Alt + Shift key, and press F1 for as many sheets as you want. Another way to insert a new worksheet by using the shortcut key is Alt + H + I + S.

How can I insert a new worksheet in Excel using the keyboard shortcut?

Press Shift + F11 to quickly insert a new worksheet.

Is there a way to insert multiple worksheets at once?

Yes, right-click on an existing sheet tab, choose “Insert” and specify the number of sheets you want to add.

How do I insert a new worksheet next to an existing one?

Right-click on an existing sheet tab, select “Insert,” and choose “Worksheet” or use the Ctrl + Shift + '+' keyboard shortcut.

What’s the method to add a new worksheet using the Ribbon menu?

Click on the “Insert” tab, then select “Worksheet” to insert a new sheet.

Category: Microsoft Excel

Recent Posts

  • 11 Paraphrasing Tools to Improve Content Quality
  • The Best PDF File Converters (Free and Easy-to-Process)
  • Examining Binary Translators Uses in the Real World – 2023
  • Free Online Tools for Writing Blog Content in 2023
  • Computer Acronyms and Abbreviations: A Complete List – 2023
© 2023 DigiRuns | Powered by Minimalist Blog WordPress Theme