How to Add Sheet in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Add Sheet in Excel



In this Compute Expert tutorial, you will learn how to add sheet in excel. Knowing how to insert a new worksheet in excel is, of course, seriously needed for anyone in optimizing the data processing and saving in this software. If you want to divide your data or its processing process into the divisions that you want in the spreadsheet, then this is the right tutorial for you to learn.


Why do We Need to Learn How to Create Sheet in Excel?


When doing spreadsheet data processing, often we need more than one worksheets. This is needed so we can divide our data with its processing process and result into several particular divisions so they can be easier to be looked at and analyzed further. Moreover, of course, if there are many things that we want to work in the spreadsheet and we put all of them in just one worksheet, then it will become very complex and maybe the data processing will be much harder to be understood compared to if we just divide them.

As a case example on the need for more than one worksheets in our job, let’s say we have one spreadsheet file which contains all the details of company products. In this company products detailed data that we have, maybe there are things like their sales performance, amount of production, salespeople allocation, and other things which are the big division of the data. Put in all the data in one worksheet will not be good because it will make it hard for us or other people when trying to look for a particular data from the products or when we want to process just parts of the data as we need in a particular time.

To place the data or its processing process and results according to its divisions like the need in the case example above, then you need to add worksheets in your spreadsheet before doing the divisions. For that, then you need to understand how to add new sheet in excel. This skill is crucial for all of us who do data processing in the spreadsheet, especially if the entries to be processed are many.


What is How to Add Sheet in Excel?


How to add sheet in excel is a function from this spreadsheet software to add a worksheet as you need it. This is mainly needed in the divisions of various things that you save and work on in the spreadsheet so they can be easier to process or find.


How to Add Sheet in Excel?


The following will explain how to add sheet in excel. In here, there will be 3 methods introduced to help you do it. The result from the three of them should the same.


Method 1 - Right-click

  1. Right-click on one of the worksheets that you already have

    How to Add Sheet in Excel - Screenshot of Step 1-1

  2. Click Insert Sheet

    How to Add Sheet in Excel - Screenshot of Step 1-2

  3. Done!

    How to Add Sheet in Excel - Screenshot of Step 1-3




Method 2 - Plus sign ( + )

  1. Click the plus sign ( + ) in the bottom of your worksheet

    How to Add Sheet in Excel - Screenshot of Step 2-1

  2. Done!

    How to Add Sheet in Excel - Screenshot of Step 2-2




Method 3 - Shortcut Buttons

  1. Press Shift + F11 simultaneously (fn + Shift + F11 in Mac)
  2. Done!

    How to Add Sheet in Excel - Screenshot of Step 3-2



Exercise


After you have learned the three methods of how to add sheet in excel, now is the time to practice your understanding in your spreadsheet file. Open a new file in your spreadsheet software. After that, try to add some new worksheets in that file by using each of the three methods. How is the result? Can you do all three?


Additional Note


If you want to add more than one worksheets at the same time, then highlight your worksheets as many as the amount that you want to add then do the steps in method 1 or 3 as explained above.



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


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert