How to Insert New Worksheet in Excel (Easy Shortcuts)

Working with MS Excel means working in the worksheets in Excel.

A worksheet is an area that has all the cells where you can store data, enter formulas, insert charts and create reports and dashboards .

When you open a new Excel workbook file , by default there is only one worksheet. Earlier versions of Excel (2013 or 2016 used to have 3 worksheets by default)

There are some simple shortcuts and techniques that you can use to quickly insert new worksheets in the same workbook in Excel .

In this tutorial, I will show you a couple of methods that you can use to insert a new worksheet in the same workbook (one at a time).

I will also show you a method to quickly insert worksheets in bulk, in case you want to add 5, 10, or 20 worksheets in one go (using a simple VBA code).

So let’s get started!

This Tutorial Covers:

Keyboard Shortcut to Insert a New Worksheet

If you are a fan of keyboard shortcuts , this is probably the fastest way to insert a new worksheet in an already open workbook in excel.

Below is the keyboard shortcut to insert a new worksheet

For this shortcut, hold the SHIFT key and then press the F11 key.

Another keyboard shortcut that does the same job is ALT + SHIFT + F1 (hold the ALT and the SHIFT keys and press the F1 key)

Personally, I find using the keyboard shortcut to be the best way to insert a new worksheet in Excel. Even if I have to insert multiple worksheets (say 3 or 5 or 10), I can still do that very quickly

Insert New Sheet Using the Plus Icon

If you’re not a big fan of keyboard shortcuts and prefer using the mouse instead, this method is for you.

At the bottom of your worksheet (in the area that has all the sheet names) , you will see the plus icon.

Clicking on this plus icon will immediately insert a new worksheet.

Insert New Sheet Using the Insert Dialog Box

Another way to insert a new sheet in Excel is by using the Insert dialog box.

Below are the steps to do this:

  • Right-click on any of the sheets
  • Click the Insert option
  • In the Insert dialog box, make sure Worksheet is already selected (which is also the default option).
  • Click on Ok

While this is not the fastest way to add a new sheet in an Excel workbook, it’s good to know as it gives you access to some other things as well.

Apart from inserting a regular worksheet, you can also use this to insert a ‘Chart Sheet’ or a ‘Macro Sheet’ using the insert dialog box.

If you’re wondering, a Chart Sheet is just like a worksheet but is meant only to hold a chart. A macro sheet is something that was used earlier before the VBA days and is no longer used.

In most cases, you won’t be needing these, but it’s good to know.

There is also the Spreadsheet Solutions tab that holds some of the templates . You can also create and get your own templates here. So the next time you need to quickly insert a template, you can do it from here.

Adding New Worksheets Using the Insert Tab in the Ribbon

And finally, you also have an option in the Excel ribbon to add a new worksheet.

To do this:

  • Click the Home tab
  • In the Cells group, click on the Insert option
  • Click on the Insert Sheet option.

This will insert one new worksheet in the open workbook

How to Insert Multiple Worksheets in One Go (One Line VBA Code)

So far, the methods that I have shown you insert one new worksheet at a time.

In case you want to insert multiple worksheets, you would have to use these methods again and again (i.e., use the keyboard shortcuts multiple times or use the plus icon multiple times).

While this works fine in most cases, if you have to insert worksheets in bulk, saying so 10 or 20 or 30 worksheets in one go, then this could be time-consuming and error-prone.

So let me show you a better way to insert multiple new worksheets in one go.

This can be done easily using a simple one-line VBA code:

The above code would instantly add 10 new sheets in the workbook in which it’s run (if you want any other number of sheets to be added, just change the value in the code)

Below are the steps to run this macro code :

  • Click the Developer tab (or use the keyboard shortcut ALT + F11) and then click on Visual Basic
  • If you don’t see the immediate window in the VB Editor , click on the View option and then click on Immediate window
  • Copy and paste the above code in the immediate window
  • Place the cursor at the end of the VBA code line and hit Enter

As soon as you hit Enter, it would instantly insert 10 new sheets in the workbook. In case you want to insert more (say 20 or 30), just change the number in the code

The good thing about using this code is that you can be sure that it would insert the right number of sheets (no chance of human error if the code is executed without any errors).

In case you need to do this quite often, you can use the below code and paste it into our Personal Macro workbook .

Once in Personal Macro Workbook, you can add it to the Quick Access Toolbar so you always have access to it in the workbook.

This way, you can easily add 10 or 20 sheets with just a single click.

Changing the Default Number of Sheets with New Excel Workbooks

If you always have a need for more worksheets in the workbook, you can change the default number of sheets you get when you open a new Excel file.

For example, you can change the setting so that you always get 5 or 10 sheets by default with every newly opened workbook.

Below are the steps to change this default setting:

  • Open any Excel workbook
  • Click the File tab
  • Click on Options. This will open the Excel Options dialog box
  • In the Excel Options dialog box, make sure the General option is selected in the left-pane
  • In the ‘When creating new workooks’ section, enter the number of sheets you want (in the Include this many sheets value).

Now when you open a new Excel workbook, it will have the specified number of worksheets.

Note that an Excel file can have a maximum of 255 sheets.

These are all the ways you can use to insert a new sheet in Excel. In most cases, you only need to add one or a couple of new sheets, so you can use the keyboard shortcut or the plus icon in the worksheet.

And in case you have a need to insert many new sheets in bulk, you can use the VBA code. Alternatively, you can also change the default number of sheets in any new Excel workbook.

I hope you found this tutorial useful!

Other Excel tutorials you may also like:

  • How to Delete Sheets in Excel (Shortcuts + VBA)
  • How to Rename a Sheet in Excel (4 Easy Ways + Shortcut)
  • How to Print Excel Sheet on One Page (Fit to One Page)
  • How to Group Worksheets in Excel (Step-by-Step)
  • How to Compare Two Excel Sheets (for differences)
  • How to Move Chart to New Sheet in Excel?
  • Count Sheets in Excel (using VBA)

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Leave a comment cancel reply.

BEST EXCEL TUTORIALS

Best Excel Shortcuts

Conditional Formatting

Excel Skills

Creating a Pivot Table

Excel Tables

INDEX- MATCH Combo

Creating a Drop Down List

Recording a Macro

© TrumpExcel.com – Free Online Excel Training

Privacy Policy  | Sitemap

Twitter | Facebook | YouTube | Pinterest | Linkedin

8 Ways to Insert a New Sheet Tab in Microsoft Excel

Do you need to add a new sheet tab to your Excel workbook? This post is going to show you all the ways that you can insert a new sheet in Excel!

Excel allows you to add multiple sheets within a workbook. This is a great way to organize your spreadsheet solutions as you can separate your inputs, data, calculations, reports, and visuals into different sheets.

Organizing your workbooks with sheets can also make the spreadsheet easier to navigate for any user.

How can you add new sheets to an Excel workbook? Follow this post to find out all the ways to add sheet tabs in Excel. You’ll even learn how to add multiple sheets based on a list!

Add a New Sheet with the New Sheet Button

add worksheet xls

The quickest and easiest way to insert a new sheet in Excel is using the New Sheet button located to the right of the current sheet tabs.

Left click on the plus sign icon to the right of the sheet tabs and Excel will create a new blank sheet in your workbook!

Add a New Sheet from the Home Tab

Adding a new sheet can also be done from the Excel ribbon.

You might think this action would be located in the Insert tab, but it will actually be found in the Home tab.

add worksheet xls

Follow these steps to insert a new sheet from the Home tab.

  • Go to the Home tab.

add worksheet xls

  • Click on the lower part of the Insert command found in the Cells section.
  • Choose the Insert Sheet option from the menu.

This will create a new sheet in your workbook.

Add a New Sheet with a Keyboard Shortcut

Good news for anyone who prefers to navigate Excel with their keyboard as much as possible! There is a dedicated keyboard shortcut for adding a new sheet.

Press Shift + F11 on your keyboard to insert a new sheet.

Add a New Sheet with Excel Options

When you create a new Excel workbook, the number of sheets it comes with will be determined by your Excel Options settings.

You can change this default so that any time you create a new workbook, it will have your desired number of blank sheets available.

The Excel Options menu allows you to customize your Excel experience with various app and workbook settings.

add worksheet xls

Follow these steps to adjust the default number of sheets in a workbook.

  • Go to the File tab.
  • Select Excel Options in the lower left.
  • Go to the General section of the Excel Options menu.
  • Scroll down to the When creating new workbooks section.
  • Change the number in the Including this many sheets input.
  • Press the OK button.

The next time you create a new Excel workbook, it will have your desired number of blank sheets.

💡 Tip : You can test out this new setting by pressing Ctrl + N to create a new workbook.

Add Multiple New Sheets with a Pivot Table

Did you know you can create multiple sheets from a list in the grid by using a pivot table?

This is a hidden gem for when you need to quickly create many sheets.

For example, suppose you need to create new sheets for each US state or each product that your company sells. This would be a tedious process with the previous methods.

If you have these sheet names as a list inside the grid, then you can create a pivot table based on this list and use the Show Report Filter Pages feature to generate the sheets for you.

add worksheet xls

This example shows a list of US states which can then be used to generate sheets with those US state names.

Follow these steps to automatically generate sheets from a list using a pivot table.

  • Create a pivot table based on your list.

💡 Tip : Check out this post to see how to insert a pivot table from your list.

add worksheet xls

  • Click and drag the sheet name field to the Filters area in the PivotTable Fields menu.

add worksheet xls

  • Go to the PivotTable Analyze tab.
  • Click on the Chevron icon in the Options command.
  • Choose the Show Report Filter Page option from the menu.

add worksheet xls

This will open the Show Report Filter Pages menu.

  • Select the field with your sheet names.

You will only see multiple field choices in the menu if you have added multiple fields to the Filters area of your pivot table.

add worksheet xls

This will create a new sheet for each unique item in your list, and each sheet will be named based on the text in your list.

add worksheet xls

Each sheet will contain a filtered version of your pivot table in cell A1. The pivot table will be filtered on the same item as the sheet name.

Add Multiple New Sheets with VBA

VBA is a great way to automate any task for Excel in the desktop app. This includes adding sheets!

You can create a VBA macro that will create new sheets based on a selected list.

Go to the Developer tab and select the Visual Basic command or press Alt + F11 to open the visual basic editor.

📝 Note : You might need to enable the Developer tab first as it is disabled by default.

add worksheet xls

Go to the Insert menu in the visual basic editor and select the Module option from the menu.

add worksheet xls

Paste the above code into the new module.

This code will loop through the selected range in your workbook and will create a new sheet for each cell. If the sheet name already exists, then this item will be skipped.

Now you will be able to select any range in your workbook and run the VBA code to automatically create multiple sheets.

Add Multiple New Sheets with Office Scripts

Another way you can automate the creation of your sheets is by using Office Scripts.

Office Scripts is the JavaScript language for automating tasks in Excel online. You will need to be using Excel on the web with a business Microsoft 365 account as this feature isn’t available otherwise.

add worksheet xls

Open Excel online and go to the Automate tab and select the New Script option. This will open the Office Script editor on the right side.

add worksheet xls

Add the above code to the editor and press the Save script button.

This code will loop through the selected range on your sheet and create a new sheet for each item in the range.

Now you select a range in your sheet and press the Run button in the Code Editor . This will run the code and create the required sheets in your workbook!

Add Multiple New Sheets with Power Automate

Microsoft Power Automate is a cloud-based service that makes it easy for end users to create and run automated workflows.

Users can build workflows in a matter of minutes, without any need for coding or complex configuration with the intuitive user interface.

The service can be used to automate a wide range of tasks, including sending emails, copying files, and creating records in databases.

Power Automate is part of the Microsoft Power Platform, which also includes Power BI and Power Apps. Together, these products provide a powerful end-to-end solution for business process automation.

But the best part is it’s available for use as part of any Microsoft 365 subscription!

add worksheet xls

You can use Power Automate to create sheets from a list inside an Excel Table . In this example, the desired sheet names are in an Excel Table with a column named Names .

📝 Note : This Excel file will need to be saved in either SharePoint or OneDrive in order to work with Power Automate.

add worksheet xls

Go to the Power Automate Portal and log in with your Microsoft credentials.

Then go to the Create tab and select an Instant cloud flow . This will allow you to run the flow manually with a button in the Power Automate portal.

add worksheet xls

Give your Flow a name then select the Manually trigger a flow option and then press the Create button.

add worksheet xls

This will open the flow builder and you can add steps to your workflow.

  • Add a List rows present in a table step and then select the relevant file and table location in the various fields.

This action will read all the items in your table of sheet names. This will be used in the next step to create and name new worksheets.

  • Add a Create worksheet step and select the same file.
  • Select the Names field from the previous List rows present in a table action.

When you add the Names field to the Name input in the Create worksheet step, it will automatically add this step into an Apply to each action. This way a worksheet will be created for each item in your list of sheet names.

Press the Save button to save your flow and it will be ready to run!

add worksheet xls

Go to the My flows menu, select the Cloud flows tab, and then press the Run button for your flow.

You don’t even have to have the file open, and the sheets will be added to your workbook!

Conclusions

Most of your workbooks will need more than one sheet, so learning how to add sheets in Excel is essential.

There are manual ways to create new sheets such as the New Sheet button, the Home tab, and a keyboard shortcut . There are all great methods when you only need to add a few sheets.

There are also several methods for adding sheets in an automated manner based on a list! VBA, Office Scripts, Power Automate, and even pivot tables can all be used for situations where you need to add a lot of sheets.

Which method do you prefer for adding sheets to your workbooks? Do you have any other tips for this? Let me know in the comments section below!

About the Author

John MacDougall

John MacDougall

Subscribe for awesome Microsoft Excel videos 😃

add worksheet xls

I’m John , and my goal is to help you Excel!

You’ll find a ton of awesome tips , tricks , tutorials , and templates here to help you save time and effort in your work.

  • Pivot Table Tips and Tricks You Need to Know
  • Everything You Need to Know About Excel Tables
  • The Complete Guide to Power Query
  • Introduction To Power Query M Code
  • The Complete List of Keyboard Shortcuts in Microsoft Excel
  • The Complete List of VBA Keyboard Shortcuts in Microsoft Excel

add worksheet xls

Related Posts

How To Make a Sheet Read-Only in Microsoft Excel

How To Make a Sheet Read-Only in Microsoft Excel

Sep 5, 2023

Are you tired of unexpected changes messing up your precious Excel data? Learn...

5 Ways to Copy a Sheet in Microsoft Excel

5 Ways to Copy a Sheet in Microsoft Excel

Apr 28, 2023

Do you need to duplicate a sheet in Excel? There are a number of useful tips...

4 Ways to Group and Ungroup Worksheets in Microsoft Excel

4 Ways to Group and Ungroup Worksheets in Microsoft Excel

Mar 2, 2023

Do you need to group or ungroup the sheets in your Excel workbook? Grouping...

Get the Latest Microsoft Excel Tips

add worksheet xls

Follow us to stay up to date with the latest in Microsoft Excel!

How to Add a Worksheet (Sheet) in Excel

- Written by Puneet

While working in Excel, users often need to add a new worksheet or delete an existing one in the current workbook. In this tutorial, we will show you how to add. We have some quick and simple methods for this.

Add a Worksheet using the Home Tab

Using the Home tab, you can add the worksheet to the left of the selected worksheet and for this, you must follow the steps below:

  • First, click on the worksheet tab to the left to which you want to add a new worksheet.
  • After that, go to the “Home” tab and click on the “Insert” icon drop-down under the “Cells” group on the ribbon.

Add a Worksheet using Right Click Option

  • First, right-click on the worksheet tab to the left of which you want to insert a new worksheet.
  • Once you click on the “Insert” option you will get a new “Insert” dialog box opened.

Using the above steps, you can add multiple worksheets at once by selecting the existing worksheets. Excel will add the same number of new worksheets you currently have selected.

Keyboard Shortcut

You can also add a new workbook to the left of the selected worksheet using the shortcut key Shift + F11 .

Add a Worksheet to the right Using Plus (+) Sign

With the (+) button, you can add the new worksheet to the right of the selected worksheet tab, but in this case, you cannot add multiple worksheets simultaneously.

  • First, select the worksheet tab to the right to which you want to add a new worksheet.
  • After that, click on the plus (+) button on the tab bar, and you will get a new worksheet added to the right of the selected worksheet.

Excel Basics / Excel Worksheet

More Tutorials

  • Consolidate Data from Multiple Worksheets
  • Rename Sheet in Excel
  • Group Worksheets in the Excel
  • View Two Sheets Side by Side in Excel
  • Change Tab Color in Excel (Worksheet Tab)
  • Add Title to a Worksheet in Excel
  • Copy or Move a Sheet (Worksheet)
  • Select All the Worksheets (Sheets)
  • Unhide an Excel Sheet or All the Sheets (Worksheet)
  • Delete a Sheet (Worksheet) in Excel
  • Duplicate a Sheet or Worksheet in Excel
  • Create a Hyperlink (Link) to an Another Worksheet
  • Lock a Sheet (Worksheet) in Excel
  • Refresh a Sheet (Worksheet) in Excel
  • Unlock a Sheet with a Password (Without Password)

1 thought on “How to Add a Worksheet (Sheet) in Excel”

Thank you for this article.

Leave a Comment Cancel reply

  • iPhone 15 Plus vs. Pro Max
  • 3 Key Tech Trends to Watch in 2024

How to Use Excel Shortcuts to Add Worksheets

Save time with these handy keyboard and mouse shortcuts

What to Know

  • Add one worksheet: Press Shift + F11 or select Plus (+) next to the sheet tabs. Or, go to Home > Insert > Insert Sheet .
  • Add multiple sheets: Press Ctrl + Shift + PgDn (right) or Ctrl + Shift + PgUp (left) to select adjacent worksheets, then press Shift + F11 .
  • Or, select a sheet, press and hold Ctrl , select adjacent sheets, then right-click on the last tab and select Insert > Worksheet > OK .

This article explains how to add new worksheets to your Excel workbooks quickly and easily using keyboard and mouse shortcuts. Instructions cover 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.

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 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  Insert Sheet  to add the new worksheets to the left of the active sheet.

Get the Latest Tech News Delivered Every Day

  • How to Select Rows, Columns, or Worksheets in Excel
  • How to Hide and Unhide Worksheets in Excel
  • How to Change Worksheet Tab Colors in Excel
  • How to Rename a Worksheet in Excel
  • The 23 Best Excel Shortcuts
  • Understand the Basic Excel Screen Elements
  • The 30 Best Gmail Keyboard Shortcuts for 2024
  • The Best Windows Keyboard Shortcuts in 2024
  • How to Move Around and Between Worksheet Tabs in Excel
  • The 12 Best Tips for Using Excel for Android in 2024
  • How to Copy a Sheet in Excel
  • How to Add and Delete Rows and Columns in Excel
  • Worksheets and Workbooks in Excel
  • How to Define and Edit a Named Range in Excel
  • Active Cell/Active Sheet
  • 3 Ways to Delete a Blank Page in Word

How to Insert a New Worksheet in Excel (2024 Guide)

When you create a new Excel workbook, you automatically create an Excel worksheet. That’s like hitting two birds with one stone 😀

However, it’s important to note that an Excel workbook is different from an Excel worksheet.

An Excel workbook is an Excel file that contains one or more worksheets. These worksheets (also called spreadsheets) consist of cells organized into rows and columns. It’s where we do the work of storing, organizing, and calculating data.

Today, learn more about Excel worksheets so you can make them work for you. In this article, you’ll learn the best ways how to insert a new worksheet in Excel, and how to rename or delete it as well 😊

Let’s go!

Table of Contents

Add worksheet with the mouse

Add worksheet with a keyboard shortcut

Add a worksheet from the ribbon menu, frequently asked questions, add worksheet with mouse clicks.

To add a new worksheet, you need to first create a new Excel workbook. You can also open an existing Excel file on your computer.

For our example, let’s create a new blank workbook.

By creating a new blank workbook, a new blank worksheet is seen on your screen 👇

If you want to see your worksheets, just look at the Sheets Tab at the bottom left of your Excel window👀umn.

Let’s add another Excel sheet to our new workbook.

All you have to do is to click the plus icon (+) next to Sheet 1.

And that’s it! You will be automatically directed to the new worksheet you can work on 😊

Simply click the plus icon if you want to add more worksheets to the workbook. The sheet name will follow as Sheets 1, 2, 3, and so on. The newly added worksheet will be the rightmost sheet in your Excel sheet tab.

One new sheet in one click 👍

Add worksheet using right-click menu option

Alternatively, you can also insert a new worksheet using the right-click menu option. Here’s how to do that 👇

  • Right-click on the Sheet2 tab.
  • Select Insert .

The Insert dialog box will appear. It will show you what you can insert.

  • Click Worksheet .
  • Finally, click OK .

The new worksheet will be inserted before the selected sheet tab. In our case, between Sheets 1 and 2.

You might be saying: “This isn’t in order.” 🤔 and you’re right.

But you don’t need to worry. You can move a sheet tab to where you want it to be.

Move your worksheet

To move an Excel worksheet, you just need to press on that sheet tab and drag .

Alternatively, you can also right-click on the sheet tab to find the Move or Copy option to move or copy the worksheet 😊

If you don’t want to insert worksheets using your mouse, you can also use the keyboard shortcut.

Keyboard shortcuts or shortcut keys can perform the same tasks and functions in Excel without having to use your mouse. Many users find keyboard shortcuts in Excel help them work more efficiently and also feel like an Excel PRO 😎

The keyboard shortcut to insert a new worksheet is Shift + F11 .

Let’s use this keyboard shortcut to insert a new worksheet into our workbook.

  • Click Sheet 3 in the sheet tab.
  • Press the Shift key and F11 on your keyboard . Make sure you hold down the Shift key before hitting the F11 key.

The new sheet is inserted before sheet 3 in the tab, that quick ⚡

If you want to insert multiple worksheets, just press the keys on your keyboard multiple times as well.

Many Microsoft Office users find keyboard shortcuts very helpful for them to work more efficiently. Aside from that, keyboard shortcuts are of great help for users with vision and mobility disabilities. They prefer keyboard shortcuts better than using touch screens or using a mouse 😊

Of course, the most obvious method to add worksheets to your workbook is using the Insert button in the Home tab of the Excel ribbon.

To insert a new worksheet from the ribbon menu, follow these easy steps.

  • Click on the Home Tab .
  • Click the Insert button in the Cells group.
  • From the drop-down list, select the Insert Sheet option.

And there you have it! One new worksheet is ready for you to use 😀

This may be the best time to rename your worksheets.

Renaming your worksheets

Renaming the worksheets in your workbook will keep your workbook organized and save you time in finding the data you want 👍

To rename your worksheets, double-click on their sheet tab like this.

Or do this 2-step method.

  • Right-click on the sheet tab.
  • Select Rename in the menu.

Now, we can then go ahead and type.

Let’s say this workbook will be a list of employees in each department. We can label the worksheets this way 😀

Sometimes, there are worksheets we no longer need or want to delete. It could be duplications or a blank one that we wish to eliminate. To do that, continue to scroll down 👇

Delete your worksheets

To delete your Excel Worksheet, right-click on the worksheet tab and select the delete option from the dialog box as shown below.

And that’s it 🙌

That’s it – Now what

Well, now you know how to work your way with worksheets in Microsoft Excel. From inserting one or multiple worksheets to organizing them so you won’t be lost in your workbooks 👍

The next time you want to insert a new sheet, try using the keyboard shortcut to feel like the Excel PRO you are on your way to becoming 😎

If your goal is to learn how to keep your data organized or level up your Excel skills, then my free Excel Intermediate training is for YOU!

I’ll be sending you FREE lessons about How to effectively clean your data, and the most important Excel functions like IF, SUMIF, and VLOOKUP 🚀

Click here to join my free email course and become an Excel PRO!

Other resources

Did you know that you can group multiple worksheets in your workbook? Learn how by clicking this link !

Want to learn more keyboard shortcuts? We’ve written 11 Best Excel Shortcuts you’ll ever need. It comes with practical examples too. Click here to learn more.

I hope you find this helpful 👋

How do I create a new sheet in Excel with the same format?

To create a new sheet with the same format as an existing worksheet, right-click on the sheet tab of the worksheet you want to copy. Then select the Move or Copy option.

Tick the checkbox “ Create a copy ” in the Move and Copy dialog box. Finally, click OK .

How do you insert a new worksheet and rename it in Excel?

You can press Shift + F11 keys to insert a new worksheet. Then double-click the tab of the current worksheet to rename it.

How to Insert a Worksheet in Microsoft Excel: A Step-by-Step Guide

Adding a new worksheet in Microsoft Excel is as simple as clicking a few buttons. Whether you need to organize your data better, or just want to start fresh, inserting a new worksheet can be done in just a few seconds.

Step by Step Tutorial on How to Insert a Worksheet in Microsoft Excel

Before we dive into the steps, let’s quickly cover what we’ll achieve by following them. By the end of this tutorial, you’ll have a brand new, blank worksheet ready for you to fill with all sorts of data.

Step 1: Open Microsoft Excel

Open Microsoft Excel on your computer.

When you open Excel, you’ll usually see a blank worksheet or the last workbook you were working on. If it’s a new worksheet you want, you’re already halfway there!

Step 2: Locate the Insert Worksheet Tab

Look for the ‘Insert Worksheet’ tab at the bottom of the screen.

This tab is usually located next to the last worksheet in your workbook. It looks like a little sheet of paper with a folded corner and a plus sign.

Step 3: Click the Insert Worksheet Tab

Click on the ‘Insert Worksheet’ tab.

Once you click this tab, Excel will automatically add a new worksheet for you. It couldn’t be easier!

After you click the insert worksheet tab, a new worksheet will appear at the bottom of your screen. It will be labeled with the next sequential letter or number in your workbook.

Tips on How to Insert a Worksheet in Microsoft Excel

  • If you want to add a worksheet at a specific location, right-click on an existing worksheet tab and choose ‘Insert’.
  • You can also use the keyboard shortcut ‘Shift + F11’ to quickly insert a new worksheet.
  • Rename your worksheet by double-clicking on the worksheet tab and typing in the new name.
  • If you need multiple new worksheets, you can hold the ‘Shift’ key and click on multiple worksheet tabs before clicking the ‘Insert’ option.
  • Keep your worksheets organized by color-coding the tabs. Right-click on a tab and choose ‘Tab Color’ to select a hue.

Frequently Asked Questions

Can i insert a new worksheet in any version of excel.

Yes, you can insert a new worksheet in all versions of Excel, although the exact steps might vary slightly.

Can I move the new worksheet to a different location?

Absolutely! Just click and drag the worksheet tab to the desired location.

Is there a limit to how many worksheets I can add?

No, Excel does not have a set limit on the number of worksheets you can add, but your computer’s memory might.

Can I add a worksheet from another workbook?

Yes, you can copy a worksheet from another workbook and paste it into your current workbook.

What if I accidentally add too many worksheets?

No worries, you can right-click the worksheet tab and select ‘Delete’ to remove any extras.

  • Open Microsoft Excel
  • Locate the Insert Worksheet Tab
  • Click the Insert Worksheet Tab

There you have it, a simple guide on how to insert a worksheet in Microsoft Excel. With just three easy steps, you can have a brand new worksheet ready to use. Remember, organizing your data is key to maintaining a clean and efficient workspace. Excel worksheets are fantastic tools for sorting, analyzing, and presenting data in a way that makes sense for your personal or business needs.

Don’t be afraid to insert multiple worksheets to keep your data separate and manageable. And always remember to save your work frequently to avoid losing any important information. With a little practice, you’ll be navigating and using Excel like a pro in no time.

So go ahead, give it a try! Once you get the hang of it, you’ll wonder how you ever managed without this handy feature. And if you ever get stuck, there’s a vast community of Excel users out there who are always willing to lend a helping hand. Happy spreadsheeting!

Matthew Burleigh Solve Your Tech

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.

Read his full bio here.

Share this:

Join our free newsletter.

Featured guides and deals

You may opt out at any time. Read our Privacy Policy

Related posts:

  • What is the Difference Between a Workbook and a Worksheet in Excel 2010?
  • Difference Between Excel Worksheet & Workbook: A Guide
  • How to Make All Columns the Same Width in Excel 2013
  • How to Print Each Worksheet of an Excel 2013 Workbook on One Page
  • How to Insert a New Worksheet in Excel 2013
  • How to Delete a Sheet in Excel 2010
  • How to Merge Excel Worksheets Into a Workbook: A Step-by-Step Guide
  • How to Center Worksheet Horizontally and Vertically in Excel 2010
  • How to Add Same Header to All Sheets in Excel 2013
  • How to Hide Tabs in Excel 2010
  • How to Make Excel Allow Multiple Users: A Step-by-Step Guide
  • How to Add a New Worksheet in Excel 2010
  • How to Display Sheet Tabs in Excel 2010
  • How to Change Font in Excel 2013 for a Whole Worksheet
  • How to Use the AutoFit Excel Shortcut for Columns and Rows
  • How to Move a Worksheet Between Workbooks in Excel 2010
  • How to Copy a Worksheet in Excel 2013
  • How to Switch a Row to a Column in Excel 2013
  • How to Create a New Workbook in Excel: Step-by-Step Guide
  • How to Freeze Multiple Rows in Excel 2013

Learn Excel

How to Insert a New Worksheet in Excel

Microsoft Excel is a powerful spreadsheet software that allows users to organize and manipulate data effectively. Knowing how to insert a new worksheet is a fundamental skill that can save you time and increase productivity. In this blog post, we will take you through a step-by-step guide on how to insert a new worksheet in Excel, so you can easily and efficiently manage your data and better organize your workbooks. Keep reading to learn more.

Step 1: Locate the Worksheet Tab

Step 2: insert a new worksheet, step 3: choose the type of worksheet to insert, step 4: rename and organize your new worksheet, 1. choose descriptive names for your worksheets, 2. use color coding to differentiate between worksheets, 3. group worksheets for easier management, 4. use appropriate formatting to enhance readability, 1. how many worksheets can i add to a single excel workbook, 2. can i insert a new worksheet at a specific location in my workbook, 3. can i copy a worksheet in excel, 4. how do i delete a worksheet in excel, 5. can i restore a deleted worksheet in excel, step-by-step guide: how to insert a new worksheet in excel.

Excel workbooks can contain multiple worksheets, each with a distinct purpose or function. If you need to add a new worksheet, follow these easy steps:

The first step to inserting a new worksheet in Excel is to locate the worksheet tab on the bottom of the screen. You can recognize the worksheet tab by its label, which displays the name of the current worksheet. By default, new workbooks contain one worksheet, labeled “Sheet1”.

To insert a new worksheet, right-click on the worksheet tab and select “Insert”. Alternatively, click on the “plus” icon located to the right of the worksheet tabs. This will open a dropdown menu with several options to insert a new worksheet.

Excel offers several options for the type of worksheet you can insert, including a blank worksheet, a spreadsheet template, and a recently used template. Select the option that best suits your needs, depending on the type of data you plan to enter.

When you insert a new worksheet in Excel, it automatically receives a new default name, such as “Sheet2”. However, you can easily rename your worksheet for better organization. To do so, right-click on the worksheet tab and select “Rename”. Enter a new name and press Enter.

If you need to manage large amounts of data, learning how to insert a new worksheet in Excel can be a game-changer. With multiple worksheets, you can easily organize your data and perform complex calculations, without worrying about clutter or confusion. By following these four simple steps, you can insert a new worksheet in Excel quickly and efficiently, and get right to work!

Best Practices for Managing Multiple Worksheets in Excel

Now that you know how to insert a new worksheet, it’s important to keep your workbooks organized and easy to navigate. Here are some best practices to help you manage your worksheets and data more effectively:

When you create a new worksheet, Excel assigns a default name based on its order (i.e., Sheet2, Sheet3, etc.). However, these names may not be meaningful to you or other users who view your workbook. To make it easier to find and work with your worksheets, rename them with descriptive names that reflect their purpose or content.

Excel allows you to change the color of worksheet tabs, which can help you quickly distinguish between multiple worksheets in a single workbook. You can use colors to code your worksheets based on their purpose, content, or importance, making it easier to find and use the one you need.

If you have a large number of worksheets in a single workbook, it can be helpful to group them based on their function or relevance. Excel allows you to create worksheet groups, which lets you manage and perform operations on multiple worksheets at once.

When you insert new worksheets and enter data, it’s important to format your cells and data to make them easier to read and understand. Some formatting options include applying borders, background colors, text formatting, and conditional formatting based on certain criteria.

Inserting a new worksheet in Excel can be a valuable tool for organizing and managing your data. By following the steps above and implementing best practices for worksheet management, you can increase your productivity, save time, and operate more efficiently in Excel.

Frequently Asked Questions (FAQs)

Here are some of the most common questions related to inserting a new worksheet in Excel:

You can add up to 1,048,576 worksheets to a single Excel workbook. However, this number may vary depending on your computer’s resources.

Yes, you can insert a new worksheet at a specific location in your workbook by right-clicking on the desired worksheet tab and selecting “Insert” in the context menu. In the “Insert” dialog box, choose the type of worksheet you want to insert and select the location where you want to add it.

Yes, you can copy a worksheet by right-clicking on the worksheet tab and selecting “Move or Copy” in the context menu. In the “Move or Copy” dialog box, choose the location where you want to copy the worksheet, and select whether you want to copy the worksheet to a new workbook or into an existing one.

To delete a worksheet in Excel, right-click on the worksheet tab and select “Delete” in the context menu. Alternatively, you can select the worksheet you want to delete and press the “Delete” key on your keyboard.

Yes, you can restore a deleted worksheet in Excel by clicking “Undo” (Ctrl + Z) immediately after deleting it. If you have already performed another operation, you might not be able to restore the worksheet. However, you can try to recover a deleted worksheet from your computer’s recycle bin if you haven’t emptied it yet.

Latest Postings

How to Protect Formulas in Excel

How to Protect Excel Sheet

How to Put a Checkmark in Excel

How to Remove Cell Lines in Excel

How to Read Excel File in Python

How to Remove Letters from a Cell in Excel

How to Remove Password in Excel

How to Restore Previous Version of Excel

How to Separate Words in Excel Using Formula

How to Run a T Test in Excel

How to Show Grid Lines on Excel

How to Share Workbook in Excel

How to Sort by Alphabetical Order in Excel

How to Strike Through Text in Excel

How to Subtract in Excel Formula

View all posts

Excel Dashboards

Excel Tutorial: How To Add Worksheet In Excel

Introduction.

Whether you're a beginner or an experienced user, knowing how to add a worksheet in Excel is a fundamental skill that can help you organize and manage your data more effectively. In this tutorial, we'll walk you through the steps to add a new worksheet in Excel and discuss its importance in improving your productivity and data management capabilities.

Key Takeaways

  • Adding a worksheet in Excel is a fundamental skill for organizing and managing data effectively.
  • Understanding the purpose of using multiple worksheets in a workbook can improve productivity.
  • Steps to add a worksheet in Excel include opening the workbook, clicking on the plus sign next to the existing worksheet, naming the new worksheet if necessary, or using the "Insert" option.
  • Organizing and color-coding worksheets can make them easier to navigate and improve workflow.
  • Using keyboard shortcuts and worksheet tabs can help in navigating between multiple worksheets efficiently.

Understanding Worksheets in Excel

A. Define what a worksheet is in Excel

A worksheet is a single spreadsheet within an Excel workbook. It is made up of cells organized in rows and columns, which can be used to input and manipulate data.

B. Explain the purpose of using multiple worksheets in a workbook

  • Organizational structure: By using multiple worksheets, you can organize different sets of data or information into separate sheets within the same workbook.
  • Data management: Multiple worksheets can make it easier to manage and analyze large amounts of data by breaking it down into more manageable chunks.
  • Data referencing: You can reference data from one worksheet to another, allowing for better data analysis and reporting.
  • Data presentation: Using multiple worksheets allows for the creation of different views and reports for the same set of data within a single workbook.

Steps to Add a Worksheet in Excel

Adding a new worksheet in Excel is a simple process that can help you organize your data and work more efficiently. Follow these steps to add a new worksheet to your Excel workbook:

Open the Excel workbook

Begin by opening the Excel workbook in which you want to add a new worksheet. Make sure the workbook is in editing mode so that you can make changes to it.

Click on the plus sign next to the existing worksheet

At the bottom of the Excel window, you will see a series of tabs representing each worksheet in the workbook. To add a new worksheet, click on the plus sign (+) located next to the existing worksheet tabs. This will create a new, blank worksheet for you to work with.

Name the new worksheet if necessary

If you want to give the new worksheet a specific name, simply double-click on the default name (such as "Sheet1") and type in the desired name. This can help you keep track of different sections or categories of data within your workbook.

Alternatively, right-click on the existing worksheet and select "Insert"

If you prefer to use a different method to add a new worksheet, you can right-click on an existing worksheet tab and select "Insert" from the context menu. This will prompt a dialog box where you can choose the type of worksheet you want to add (e.g., a blank worksheet, a worksheet based on a template, etc.).

Organizing Your Worksheets

When working with multiple worksheets in Excel, it's important to keep them organized to improve your workflow and make it easier to navigate through your data. Here are some tips for organizing your worksheets:

  • Rename the Default Sheet Names: Excel often starts with default worksheet names (Sheet1, Sheet2, etc.). It's a good practice to rename these worksheets based on the content they hold. For example, if one worksheet contains sales data, you can rename it to "Sales Data."
  • Use Descriptive Names: Make sure the names you choose are descriptive and easy to understand. Avoid using vague names that could lead to confusion.
  • Apply Color to Tabs: You can use the "Tab Color" option to assign different colors to your worksheet tabs. For example, you can use green for financial data, red for tracking sheets, and blue for reference sheets. This will visually differentiate the worksheets and make it easier to navigate through them.
  • Use Consistent Color Codes: Establish a color-coding system and stick to it across all your workbooks. Consistency will help you and your colleagues quickly identify the purpose of each worksheet.
  • Put Related Sheets Together: If your workbook contains multiple worksheets related to a specific project or task, arrange them next to each other. This will make it easier to access the information you need without having to scroll through other unrelated sheets.
  • Use Grouping or Outlining: Excel allows you to group or outline your worksheets, creating a hierarchical structure that helps you quickly collapse or expand related sheets. This feature is especially useful when working with large workbooks containing numerous worksheets.

Navigating Between Worksheets

When working with multiple worksheets in Excel, it's important to know how to easily navigate between them. There are a couple of methods you can use to switch between worksheets efficiently.

One of the quickest ways to navigate between worksheets in Excel is by using keyboard shortcuts. This method can save you time and make your workflow more efficient.

  • Ctrl + Page Up/Down: Pressing Ctrl and the Page Up or Page Down keys allows you to move to the previous or next worksheet in the workbook.
  • Ctrl + Tab: Similar to switching between tabs in a web browser, pressing Ctrl and Tab simultaneously lets you cycle through the worksheets in the workbook.

The worksheet tabs are located at the bottom of the Excel window and provide a visual way to switch between worksheets.

  • Clicking on Tabs: Simply click on the tab of the worksheet you want to navigate to. This method is straightforward and easy to use, especially when you have a small number of worksheets.
  • Scrolling Through Tabs: If you have a lot of worksheets and they don't all fit on the screen, you can use the arrows at the left and right ends of the tab bar to scroll through the tabs.

Using Multiple Worksheets Effectively

When working with complex data in Excel, it can be beneficial to use multiple worksheets to organize and analyze your information more effectively. In this tutorial, we will discuss how to link data between worksheets and the benefits of using multiple worksheets for complex data analysis.

A. Linking Data Between Worksheets

Linking data between worksheets is a useful feature in Excel that allows you to easily reference data from one worksheet to another. This can be done by using cell references or formulas to pull data from one worksheet into another.

  • Cell References: To link data between worksheets using cell references, simply select the cell in the target worksheet where you want the data to appear, then type = followed by the name of the source worksheet, followed by an exclamation mark (!), and the cell reference of the data you want to link.
  • Formulas: Another way to link data between worksheets is by using formulas such as =SUM or =AVERAGE to calculate data from multiple worksheets.

B. Benefits of Using Multiple Worksheets for Complex Data Analysis

There are several benefits to using multiple worksheets for complex data analysis in Excel.

  • Organization: By separating different sets of data onto separate worksheets, you can keep your information organized and easy to navigate.
  • Complex Analysis: When dealing with large amounts of data, using multiple worksheets allows you to perform more complex analysis and calculations without cluttering a single worksheet.
  • Collaboration: Multiple worksheets make it easier for team members to work on different aspects of a project simultaneously, as each can have their own worksheet to work on and then merge the data at the end.

Understanding how to add a worksheet in Excel is crucial for proper data management and organization. It allows you to effectively categorize your data and maintain a clear overview of your work. Therefore, it is essential for anyone working with Excel to master this skill.

We encourage our readers to practice adding and organizing worksheets regularly to improve their Excel proficiency. The more you practice, the more confident and efficient you will become in utilizing this powerful tool for data management.

Excel Dashboard

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

Excel Tutorial: What Does #### Mean In Excel

Excel Tutorial: What Does #### Mean In Excel

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Making Write 15 Minutes On A Timesheet

Making Write 15 Minutes On A Timesheet

Making Identify Sheet Sizes

Making Identify Sheet Sizes

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

  • Choosing a selection results in a full page refresh.

sheets icon

Cloud Storage

gmail icon

Custom Business Email

Meet icon

Video and voice conferencing

calendar icon

Shared Calendars

docs icon

Word Processing

Spreadsheets

slides icon

Presentation Builder

forms icon

Survey builder

google workspace

Google Workspace

An integrated suit of secure, cloud-native collaboration and productivity apps powered by Google AI.

Make data-driven decisions, in Google Sheets

Create and collaborate on online spreadsheets in real-time and from any device.

  • For my personal use
  • For work or my business

icon for add comment button

T h e s e   n u m b e r s   l o o k   v e r y   s t r o n g !

comment box buttons

Collaborate on data, from anywhere

Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Sheets Supercharge Teamwork

Get to insights faster with built-in intelligence

Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Sheets write faster

Seamlessly connect to other Google apps

Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Sheets Seamlessly connects

Extend collaboration and intelligence to Excel files

Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.

Sheets collaboration

Build custom solutions

Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script.

Always work with fresh data

Always work with fresh data

With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.

Seamlessly connect to critical data

Seamlessly connect to critical data

Pull in and analyze data from the other tools you use, like customer data from Salesforce. Enterprise customers can also use Connected Sheets to analyze billions of rows of BigQuery data in Sheets – without writing any code.

Security, compliance, and privacy

badge ISO IEC

Secure by default

We use industry-leading security measures to keep your data safe, including advanced malware protections. Sheets is also cloud-native, eliminating the need for local files and minimizing risk to your devices.

Encryption in transit and at rest

All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.

Compliance to support regulatory requirements

Our products, including Sheets, regularly undergo independent verification of their security, privacy, and compliance controls .

Private by design

Sheets adheres to the same robust privacy commitments and data protections as the rest of Google Cloud’s enterprise services .

privacy icon

You control your data.

We never use your sheets content for ad purposes., we never sell your personal information to third parties., find the plan that’s right for you, google sheets is a part of google workspace.

Every plan includes

keep icon

Collaborate from anywhere, on any device

Access, create, and edit your spreadsheets wherever you are — from any mobile device, tablet, or computer — even when offline.

Google Play store

Get a head start with templates

Choose from a variety of dashboards, project trackers, and other professionally-designed templates to kick things off quickly..

Sheets Template Invoice

Visit the Sheets Template Gallery for more.

Ready to get started?

add worksheet xls

Insert an object in your Excel spreadsheet

You can use Object Linking and Embedding (OLE) to include content from other programs, such as Word or Excel.

OLE is supported by many different programs, and OLE is used to make content that is created in one program available in another program. For example, you can insert an Office Word document in an Office Excel workbook. To see what types of content that you can insert, click Object in the Text group on the Insert tab. Only programs that are installed on your computer and that support OLE objects appear in the Object type box.

An introduction to linked and embedded objects

If you copy information between Excel or any program that supports OLE, such as Word, you can copy the information as either a linked object or an embedded object. The main differences between linked objects and embedded objects are where the data is stored and how the object is updated after you place it in the destination file. Embedded objects are stored in the workbook that they are inserted in, and they are not updated. Linked objects remain as separate files, and they can be updated.

Linked and embedded objects in a document

1. An embedded object has no connection to the source file.

2. A linked object is linked to the source file.

3. The source file updates the linked object.

When to use linked objects

If you want the information in your destination file to be updated when the data in the source file changes, use linked objects.

With a linked object, the original information remains stored in the source file. The destination file displays a representation of the linked information but stores only the location of the original data (and the size if the object is an Excel chart object). The source file must remain available on your computer or network to maintain the link to the original data.

The linked information can be updated automatically if you change the original data in the source file. For example, if you select a paragraph in a Word document and then paste the paragraph as a linked object in an Excel workbook, the information can be updated in Excel if you change the information in your Word document.

When to use embedded objects

If you don't want to update the copied data when it changes in the source file, use an embedded object. The version of the source is embedded entirely in the workbook. If you copy information as an embedded object, the destination file requires more disk space than if you link the information.

When a user opens the file on another computer, he can view the embedded object without having access to the original data. Because an embedded object has no links to the source file, the object is not updated if you change the original data. To change an embedded object, double-click the object to open and edit it in the source program. The source program (or another program capable of editing the object) must be installed on your computer.

Changing the way that an OLE object is displayed

You can display a linked object or embedded object in a workbook exactly as it appears in the source program or as an icon. If the workbook will be viewed online, and you don't intend to print the workbook, you can display the object as an icon. This minimizes the amount of display space that the object occupies. Viewers who want to display the information can double-click the icon.

Embed an object in a worksheet

Click inside the cell of the spreadsheet where you want to insert the object.

Object icon on the ribbon

In the Object dialog box, click the Create from File tab.

Click Browse , and select the file you want to insert.

If you want to insert an icon into the spreadsheet instead of show the contents of the file, select the Display as icon check box. If you don’t select any check boxes, Excel shows the first page of the file. In both cases, the complete file opens with a double click. Click OK .

Note:  After you add the icon or file, you can drag and drop it anywhere on the worksheet. You can also resize the icon or file by using the resizing handles. To find the handles, click the file or icon one time.

Insert a link to a file

You might want to just add a link to the object rather than fully embedding it. You can do that if your workbook and the object you want to add are both stored on a SharePoint site, a shared network drive, or a similar location, and if the location of the files will remain the same. This is handy if the linked object undergoes changes because the link always opens the most up-to-date document.

Note:  If you move the linked file to another location, the link won’t work anymore.

Click the Create from File tab.

Click Browse , and then select the file you want to link.

Select the Link to file check box, and click OK .

Create a new object from inside Excel

You can create an entirely new object based on another program without leaving your workbook. For example, if you want to add a more detailed explanation to your chart or table, you can create an embedded document, such as a Word or PowerPoint file, in Excel. You can either set your object to be displayed right in a worksheet or add an icon that opens the file.

This embedded object is a Word document.

On the Create New tab, select the type of object you want to insert from the list presented. If you want to insert an icon into the spreadsheet instead of the object itself, select the Display as icon check box.

Click OK . Depending on the type of file you are inserting, either a new program window opens or an editing window appears within Excel.

Create the new object you want to insert.

When you’re done, if Excel opened a new program window in which you created the object, you can work directly within it.

You can edit the embedded Word document directly in Excel.

When you’re done with your work in the window, you can do other tasks without saving the embedded object. When you close the workbook your new objects will be saved automatically.

Note:  After you add the object, you can drag and drop it anywhere on your Excel worksheet. You can also resize the object by using the resizing handles. To find the handles, click the object one time.

On the Insert tab, in the Text group, click Object .

The Object option is on the Insert tab.

Need more help?

You can always ask an expert in the Excel Tech Community  or get support in  Communities .

Facebook

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

add worksheet xls

Microsoft 365 subscription benefits

add worksheet xls

Microsoft 365 training

add worksheet xls

Microsoft security

add worksheet xls

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

add worksheet xls

Ask the Microsoft Community

add worksheet xls

Microsoft Tech Community

add worksheet xls

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Worksheets.Add method (Excel)

  • 5 contributors

Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet.

expression . Add ( Before , After , Count , Type )

expression A variable that represents a Worksheets object.

Return value

An Object value that represents the new worksheet, chart, or macro sheet.

If Before and After are both omitted, the new sheet is inserted before the active sheet.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Was this page helpful?

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

Fantasy Baseball

Fantasy Baseball

2024 fantasy baseball cheat sheet: Customizable rankings and projections tool

PHILADELPHIA, PA - May 22: Corbin Carroll #7 of the Arizona Diamondbacks in action against the Philadelphia Phillies during a game at Citizens Bank Park on May 22, 2023 in Philadelphia, Pennsylvania. (Photo by Rich Schultz/Getty Images)

Look, I get it. You may not agree with Jake’s rankings. At all. Or perhaps you want to give Freddie Freeman seven more home runs than we did in our projections. Maybe you play in a points league that awards 2.75 points for a stolen base.

Whatever the case may be, this is the tool you’re looking for.

Dom Luszczyszyn is the mastermind behind a fantasy hockey cheat sheet and works with Jake each year to create this tool that allows you to input your league settings, tweak projections, and basically draft with an optimized list of rankings fully customized to your league .

Check out our fantasy baseball draft kit: Projections, auction values, rankings, sleepers and more!

  • We try to make it better and tweak it yearly, but there will probably still be some little bugs. Your feedback is essential in getting this perfect. So please drop any problems you’re encountering into the comments.

How to use this fantasy baseball cheat sheet — PLEASE READ

Step 1: enable editing (if asked/needed).

You should only need to do this the first time opening a new download.

Step 2: Scoring settings

The far left tab across the bottom is “Settings.” If you’re in a points league, put the point values in the cells next to the corresponding category. So if your league awards 10 points for a win, put a 10 in the cell to the right of “W”:

add worksheet xls

For Roto leagues, delete (if needed) the point values you don’t use and put a “1” in the categories you score. So a 5×5 Roto league that scores OBP instead of average would look like this:

add worksheet xls

Now go to the right of this page, and put in your number of teams (10/12/15 whatever) — it’ll change the “Players Selected Above Replacement” numbers in yellow. And here’s something for the more advanced spreadsheeter. If you want to assign a little more oomph to a particular position, change the “Players Selected Above Replacement” for that position and the sheet will adjust. A higher number = that position becomes more valuable. A lower number = the importance is decreased. It’s currently optimized to fit Jake’s rankings, but your tastes may vary.

Advertisement

***** Now this is very important (thus the asterisks) — enter your “format” ( Points or Categories )  AND… if you are playing in Points , make sure Positions options are all set to “ No ” (the points VORP calculation doesn’t use that since it’s already factored in accounting for all positions). The 1B+3B and 2B+SS are “Yes” to account for MI and CI positions/rankings on those tabs.

Also, very important — and ONLY if you want all pitchers ranked regardless of position or hitters all ranked with no position variability. Change “No” to “Yes” for SP+RP and/or All Hitters to get overall VORPs.

Then go to the “Rankings” tab.

Step 3: The Rankings Tab

The easiest way to do this is sorting by Rank. Hit the little triangle, sort by “ascending” and it’ll auto-sort for you. If you want to nerd out, you can also sort by VORP, in which case you want to go with “descending” and you may have to click it twice to get it to work.

We realize this seems simple, but it takes into account months of projections, some very serious spreadsheet math, standard deviation, replacement level players and much more. It will also be updated all preseason with reactions to news, signings, trades and everything in between. 

Step 4: Miscellany and Fixes

1.  You can do a lot with this tool. If you don’t like the projections — you can change them. For instance, we went to the “Hitters” tab and changed Spencer Torkelson’s HR projection from 29.3

add worksheet xls

When you go back to the rankings tab, you can see he’s jumped up to 59th (…and then you just sort again to re-order the list):

add worksheet xls

***IMPORTANT: ONLY CHANGE THE PROJECTIONS IN THE “HITTERS” OR “PITCHERS” TAB**** They won’t take anywhere else.

2. Points league players may also notice some fringe categories missing , like CG, SHO, and CYC. We can’t project who’s going to hit for the cycle. And shutouts and complete games are such an infrequent occurrence, we’re leaving it to you to assign the one or two per year to pitchers and boosting their value manually — and same for CS, QS, Holds and BS — those are there for you to enter if you want/use them.

3. If you play in an AL or NL-only league , just hit the triangle under “League” on the Rankings tab, and check the corresponding league. Free Agents default league is NA.

4. ADP is intentionally blank . That’s there if you want to fill it in, and it depends on when (and where) you draft. Unfortunately, with the frequent changes (sometimes daily) and depending on your site (ESPN, Yahoo, etc.) there is no good way to get automated ADP.

5. Saves + Holds works for us if we use 1 point for Saves and 0.75 for Holds.

Step 5: My Team

There’s a “My Team” tab that will let you punch in your team (or a practice team) and see what the projected totals will be. It’s especially important if you’re doing a mock — or a solitaire mock and want to see if your team will compete for a title in Roto, as you can look at past totals and see where you’d finish in the ranks. Just copy the player’s name (or type it in, but spell it correctly!) from the Rankings tab and paste it into the My Team one at their position.

Special “Steps”

  • You need to delete the player from multiple tabs: Position (they are: 1B, RP, etc.), Hitters (or Pitchers), 1B+3B or 2B+SS (if an infielder), SP+RP (any pitcher), Std Dev and Rankings. Also, this is going to skew the VORP a bit, which you may/might not want.

Mono (AL or NL only) Leagues

  • On the Rankings tab, there is a column to sort by only AL or NL for the league. Just choose which you want, and voíla .

Adding Categories, etc.

  • If you have categories we don’t account for in Settings, you can swap one of the ones listed for the one you use (ex: Change GS for Shutouts after changing the GS column on Pitchers tab).

Alright! Ready to experience the tool?!

Download: 2024 customizable rankings tool (updated 2/26).

(Photo by Rich Schultz/Getty Images)

Get all-access to exclusive stories.

Subscribe to The Athletic for in-depth coverage of your favorite players, teams, leagues and clubs. Try a week on us.

' height=

Introducing Gemini for Google Workspace, plus more AI offerings to better meet your business needs

What’s changing , who’s impacted, why it’s important.

  • Research, brainstorm and analyze information in Gemini ( gemini.google.com ), with access to Google’s 1.0 Ultra and enterprise-grade data protections
  • Double-check responses to validate information in Gemini ( gemini.google.com )
  • Chat with Gemini ( gemini.google.com ) to get the words and visuals just right and easily bring the output from Gemini to your new or existing document, presentation, or email
  • Help you write and refine emails in Gmail—even on the go from your mobile device
  • Help you write, refine, and proofread content in Google Docs
  • Generate original images for your presentations directly in Google Slides
  • Create plans for projects in Google Sheets with just a simple prompt
  • Look your best in Google Meet with studio look 
  • Generate background images in Google Meet
  • Use translated captions in Google Meet

Additional details

Getting started.

  • Admins: 
  • See here for more information about adding Gemini to your Google Workspace plan .
  • Visit the Help Center to learn more about turning Gemini (gemini.google.com) on or off for your users , and about  Gemini Enterprise and Gemini Business for Google Workspace  in general.

Availability

  • Gemini Business is available as an add-on for Google Workspace Business Starter, Business Standard, Business Plus, Enterprise Starter, Enterprise Standard, Enterprise Plus, Frontline Starter, Frontline Standard, Enterprise Essentials, Enterprise Essentials Plus, and Google Workspace for Nonprofits. We're working to bring Gemini for Workspace to our education customers, and we look forward to sharing more about this in the coming weeks.
  • *Gemini ( gemini.google.com ) is not currently available to Gemini Enterprise and Gemini Business users working in Hong Kong, France, or French territories. However, all other Gemini for Google Workspace features are supported in these locales. 
  • Gemini for Google Workspace features are only available for users over the age of 18.
  • Workspace Blog: Enterprise-grade Gemini is now available for teams of all sizes with Google Workspace
  • The Keyword: The next chapter of our Gemini era
  • Workspace Blog: How we're protecting your Google Workspace data in the era of generative AI
  • Google Workspace Admin Help: Gemini for Google Workspace 

Share on Twitter

Filter by product

  • Accessibility
  • Admin console
  • Cloud Search
  • Directory Sync
  • Drive for desktop
  • Education Edition
  • G Suite for Education
  • G Suite for Government
  • Google Apps Script
  • Google Calendar
  • Google Chat
  • Google Classroom
  • Google Cloud Directory Sync
  • Google Docs
  • Google Drawings
  • Google Drive
  • Google Forms
  • Google Hangouts
  • Google Keep
  • Google Maps
  • Google Meet
  • Google Meet Hardware
  • Google Photos
  • Google Sheets
  • Google Sites
  • Google Slides
  • Google Tasks
  • Google Vault
  • Google Voice
  • Google Workspace
  • Google Workspace Add-ons
  • Google Workspace for Education
  • Google Workspace Marketplace
  • Google Workspace Migrate
  • Marketplace
  • Microsoft Exchange
  • Microsoft Outlook
  • Premier Edition
  • Rapid Release
  • Rapid Releases
  • Scheduled Release
  • Security and Compliance
  • Weekly Recap
  • What's New

Filter by date

Subscribe by feed, subscribe by email, localized google workspace updates, useful links, join the official community for google workspace administrators.

In the Google Cloud Community, connect with Googlers and other Google Workspace admins like yourself. Participate in product discussions, check out the Community Articles, and learn tips and tricks that will make your work and life easier. Be the first to know what's happening with Google Workspace.

______________

Learn about more Google Workspace launches

On the “What’s new in Google Workspace?” Help Center page, learn about new products and features launching in Google Workspace, including smaller changes that haven’t been announced on the Google Workspace Updates blog.

IMAGES

  1. Download Basic Addition Practice Sheet Excel Template

    add worksheet xls

  2. Single Digit Addition Worksheets With Pictures

    add worksheet xls

  3. 2 Digit Addition Without Regrouping

    add worksheet xls

  4. Addition Work Sheet in Excel

    add worksheet xls

  5. Add worksheets in XLS documet, Get worksheet using its name, Access

    add worksheet xls

  6. Counting On to Add Worksheet

    add worksheet xls

VIDEO

  1. 7x7 lishi style pick ready!

  2. Excel Tutorial: Across Worksheets

  3. Add and Write#add#maths#worksheet #funny#mathsactivity#activitiesforkids#learningvideos#trending

  4. Tutorial conversie Worksheet XLS

  5. List All Sheets in an Excel Workbook

  6. #excelshorts Automatically insert sheets in Excel

COMMENTS

  1. Insert or delete a worksheet

    Or, select Home > Insert > Insert Sheet. Rename a worksheet Double-click the sheet name on the Sheet tab to quickly rename it. Or, right-click on the Sheet tab, click Rename, and type a new name. Move a worksheet To move the tab to the end, right-click the Sheet tab then Move or Copy > (move to end) > OK . Or, click and drag to tab to any spot.

  2. How to Insert New Worksheet in Excel (Easy Shortcuts)

    Click the Insert option In the Insert dialog box, make sure Worksheet is already selected (which is also the default option). Click on Ok While this is not the fastest way to add a new sheet in an Excel workbook, it's good to know as it gives you access to some other things as well.

  3. VBA Add New Sheet

    Add a sheet with a name You can also define a worksheet name when creating the new sheet: Sheets.Add.Name = "NewSheet" Create new worksheet with name from a cell Or use a cell value to name a new worksheet: Sheets.Add.Name = range("a3").value Add worksheet before / after another worksheet

  4. 8 Ways to Insert a New Sheet Tab in Microsoft Excel

    The quickest and easiest way to insert a new sheet in Excel is using the New Sheet button located to the right of the current sheet tabs. Left click on the plus sign icon to the right of the sheet tabs and Excel will create a new blank sheet in your workbook! Add a New Sheet from the Home Tab

  5. How to Add a Worksheet (Sheet) in Excel

    First, click on the worksheet tab to the left to which you want to add a new worksheet. After that, go to the "Home" tab and click on the "Insert" icon drop-down under the "Cells" group on the ribbon. Now, select the "Insert Sheet" option from the drop-down list.

  6. How to Use Excel Shortcuts to Add Worksheets

    Updated on December 2, 2020 What to Know Add one worksheet: Press Shift + F11 or select Plus (+) next to the sheet tabs. Or, go to Home > Insert > Insert Sheet. Add multiple sheets: Press Ctrl + Shift + PgDn (right) or Ctrl + Shift + PgUp (left) to select adjacent worksheets, then press Shift + F11.

  7. How to Insert a New Worksheet in Excel (2024 Guide)

    One new sheet in one click Add worksheet using right-click menu option Alternatively, you can also insert a new worksheet using the right-click menu option. Here's how to do that Right-click on the Sheet2 tab. Select Insert. The Insert dialog box will appear. It will show you what you can insert. Click Worksheet. Finally, click OK.

  8. Excel Tutorial: How To Add Worksheets In Excel

    Step 1: Open Microsoft Excel and access the workbook where you want to add a new worksheet. Step 2: Make sure you are on the correct workbook tab where you want to add the new worksheet. B. Clicking on the "+" button

  9. How to Insert a Worksheet in Microsoft Excel: A Step-by-Step Guide

    If you want to add a worksheet at a specific location, right-click on an existing worksheet tab and choose 'Insert'. You can also use the keyboard shortcut 'Shift + F11' to quickly insert a new worksheet. Rename your worksheet by double-clicking on the worksheet tab and typing in the new name. If you need multiple new worksheets, you ...

  10. How to Insert a New Worksheet in Excel

    Step 2: Insert a New Worksheet. To insert a new worksheet, right-click on the worksheet tab and select "Insert". Alternatively, click on the "plus" icon located to the right of the worksheet tabs. This will open a dropdown menu with several options to insert a new worksheet.

  11. Insert or delete a worksheet in Microsoft Excel

    In Microsoft Excel, you can easily add, rename, and delete worksheets in your workbook. Learn more at the Excel Help Center: https://msft.it/6000TiutM Subsc...

  12. How to Add Multiple Worksheets to Excel & Google Sheets

    Shortcuts - Insert Sheets To add multiple worksheets using the keyboard, first hold the SHIFT key and choose the number of sheets you want to add. With the sheets selected, press ALT + SHIFT + F1, or SHIFT + F11. Use either shortcut multiple times to quickly add more sheets (without needing a certain number of existing sheets).

  13. How To Quickly Insert A New Worksheet In Excel

    Efficiently insert new worksheets using Excel's various tools: Excel offers several options for quickly adding a new worksheet, including using the menu, ribbon, or keyboard shortcuts. Choose the method that best suits your workflow to save time and increase productivity.

  14. Create a new workbook

    Open Excel. Select Blank workbook or press Ctrl+N. Start typing. Create a workbook from a template Select File > New. Double-click a template. Click and start typing. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Insert or delete a worksheet Need more help? Want more options?

  15. 7 Excel Shortcuts For Adding New Worksheets

    However, this is slow. Luckily, there are seven Excel shortcuts to add new worksheets: Use the keyboard shortcut Shift + F11. This creates a worksheet on the left. Use Ctrl + Shift + T. This creates a worksheet with the same formatting. Right-click the worksheet tab and select "Insert".

  16. How to Insert Sheet in Excel

    Here, you'll see a few simple steps on how to easily insert Sheet in Excel, thanks to which you can make your work and data more organized. There are several...

  17. Excel Tutorial: How To Add Worksheet In Excel

    Steps to add a worksheet in Excel include opening the workbook, clicking on the plus sign next to the existing worksheet, naming the new worksheet if necessary, or using the "Insert" option. Organizing and color-coding worksheets can make them easier to navigate and improve workflow.

  18. Insert New Worksheet in Excel

    Step 1: In your computer's search box, type excel; it will show you the excel app in your computer. Step 2: Click on the Excel version app on your computer. Step 3: If any of the workbooks are already open, you will directly see a new workbook and a total of 3 worksheets. Now we will see how to modify the number of worksheets by default.

  19. Sheets.Add method (Excel)

    Sheets.Add method (Excel) Article 03/29/2022 9 contributors Feedback In this article Syntax Parameters Return value Remarks Example Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet. Syntax expression. Add ( Before, After, Count, Type) expression A variable that represents a Sheets object. Parameters

  20. Google Sheets: Online Spreadsheet Editor

    Or add custom functions, menu items, and macros with Apps Script. Always work with fresh data With Sheets, everyone's always working on the latest version of a spreadsheet.

  21. Ways to add values in a spreadsheet

    One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.)

  22. Insert an object in your Excel spreadsheet

    Newer versions Office 2013 Embed an object in a worksheet Click inside the cell of the spreadsheet where you want to insert the object. On the Insert tab, in the Text group, click Object . In the Object dialog box, click the Create from File tab. Click Browse, and select the file you want to insert.

  23. Worksheets.Add method (Excel)

    Syntax Parameters Return value Remarks Creates a new worksheet, chart, or macro sheet. The new worksheet becomes the active sheet. Syntax expression. Add ( Before, After, Count, Type) expression A variable that represents a Worksheets object. Parameters Expand table Return value

  24. Excel full budget tutorial

    Learn how to make this budget sheet with me in just 9 minutes. Track budget line items and add category and priority, while getting easy to see visuals to show where spend is going.

  25. 2024 fantasy baseball cheat sheet: Customizable rankings and

    Look, I get it. You may not agree with Jake's rankings. At all. Or perhaps you want to give Freddie Freeman seven more home runs than we did in our projections. Maybe you play in a points league ...

  26. Introducing Gemini for Google Workspace, plus more AI offerings to

    On February 8, we announced the next chapter of our Gemini era.As part of this change, starting today, the Duet AI for Google Workspace Enterprise add-on is now called Gemini Enterprise.Gemini Enterprise includes full usage and access to generative AI features in Workspace, such as help me write, organize, and visualize, and more.