How to Add/Create Sheets in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Add/Create Sheets in Excel



In this tutorial, you will learn how to add/create sheets in excel completely.

When working in excel, we sometimes need to add more worksheets so we can add more contents to our workbook. To do that without any problem, we should master the methods to add worksheets in excel.

Want to learn and understand those methods? Read this tutorial until its last part!







How to Create a Sheet in Excel 1: Right-Click

There are three basic methods to create a new blank sheet in excel that we will discuss here. The first method utilizes the right-click action that we can do in the relevant location in our excel workbook.

The way to implement this method is quite easy as you can see in its two implementation steps below.

  1. Right-click on one of your worksheet tabs and click Insert Sheet. You can locate your worksheet tabs in the bottom-left part of your excel workbook

    How to Add/Create Sheets in Excel - Screenshot of the Right-Click Method, Step 1

  2. Done!

    How to Add/Create Sheets in Excel - Screenshot of the Right-Click Method, Step 2




How to Add/Create a Sheet in Excel 2: Insert Worksheet Symbol

This second method to add a sheet in excel is also easy to implement. We use the insert worksheet symbol we can find on the outer right of our worksheet tabs to apply this method.

  1. Click the insert worksheet symbol you can find in the outer right of your worksheet tabs

    How to Add/Create Sheets in Excel - Screenshot of the Insert Worksheet Symbol Method, Step 1

  2. Done!

    How to Add/Create Sheets in Excel - Screenshot of the Insert Worksheet Symbol Method, Step 2






How to Add/Create a Sheet in Excel 3: Insert Button

The third method we will discuss involves a button in our excel ribbon.

  1. Go to your Home tab, click the Insert dropdown button there, and choose Insert Sheet from the dropdown list

    How to Add/Create Sheets in Excel - Screenshot of the Insert Worksheet Symbol Method, Step 1

  2. Done!

    How to Add/Create Sheets in Excel - Screenshot of the Insert Worksheet Symbol Method, Step 2




How to Add/Create a Copied Sheet in Excel

Besides creating a blank worksheet, you can also create a new sheet that copies its content from your current worksheet. To add this copied sheet to your workbook, follow these steps.

  1. Right-click on the tab of the worksheet which content you want to copy to create your new sheet. Then, click Move or Copy…

    How to Add/Create Sheets in Excel - Screenshot of the Copy Method, Step 1

  2. Check the “Create a Copy” checkbox in the dialog box that shows up. You can do that by clicking on it if it doesn’t have a checkmark yet

    How to Add/Create Sheets in Excel - Screenshot of the Copy Method, Step 2

  3. Select the sheet tab where you want to place your new worksheet tab before it in the Before Sheet box. If you want to place your new worksheet tab at the end of your worksheet tabs, select (move to end)

    How to Add/Create Sheets in Excel - Screenshot of the Copy Method, Step 3

  4. Click OK

    How to Add/Create Sheets in Excel - Screenshot of the Copy Method, Step 4

  5. Done!

    How to Add/Create Sheets in Excel - Screenshot of the Copy Method, Step 5




How to Add/Create Multiple Sheets in Excel at Once

To add multiple sheets, select a number of worksheet tabs according to the number of worksheets you want to add. You can select the multiple worksheet tabs by clicking the most left of the worksheet tabs you want to select first. Then, hold the Shift button and click the most right tab of the worksheet tabs you want to select simultaneously.



You should get something like this in your worksheet tabs after you do that.

How to Add/Create Sheets in Excel - Screenshot of the Multiple Sheets Selection Result Example

Next, just implement the steps of the right-click or insert button method we have discussed before. You can right-click on the worksheet tabs you select and select Insert Sheet. Alternatively, you can go to the Home tab, click the Insert dropdown button there, and choose Insert Sheet.

Implementing either of those two methods will make you add the multiple sheets you want! Those sheets tabs’ location will be just before the most left tab of the worksheet tabs you select.

How to Add/Create Sheets in Excel - Screenshot of the Multiple Sheets Addition Result Example



Shortcut to Add/Create Sheets in Excel

Need to add a sheet in excel quickly? You can just press the Shift and F11 (Fn, Shift, and F11 in Mac) buttons simultaneously on your keyboard. By doing that, you will immediately add a new blank sheet to your excel workbook!



Exercise

After you have learned the methods to add sheets in excel, now is the time to practice your understanding.

Open a new excel file. After that, try to add some new worksheets to the excel file by implementing the methods you have learned.

How is the result? Can you do it?



Additional Note

You can add as many worksheets as you want in an excel file as long as your computer memory (RAM) allows it.



Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert