How to Add a New Worksheet in Excel 2010

The Microsoft Excel files that you have saved on your computer, and that you occasionally share with work colleagues or teachers, have file names with an .xls or .xlsx filename extension. This entire file is known as a workbook. Each Excel workbook can contain multiple different spreadsheets called worksheets. You can navigate between these worksheets by clicking the different tabs at the bottom of the Excel window.

But if you have already used all of the worksheets that are in your workbook, then you may be wondering how to add a new one to your workbook. Fortunately it is something that can be accomplished in just a few short steps by following our guide below.

How to Insert a New Worksheet in Excel 2010

The steps in this article were written using Microsoft Excel 2010. The process for adding a new worksheet may vary in other versions of Excel.

Step 1: Open your workbook in Excel 2010.

Step 2: Locate the worksheet tabs at the bottom of the window. If you do not see any worksheet tabs there, then they may be hidden. Follow the steps here to unhide sheet tabs in Excel 2010.

locate the worksheet tabs

Step 3: Click the Insert New Worksheet button to the right of the last worksheet tab.

insert new worksheet tab

If you would prefer to add a new worksheet through the navigational ribbon at the top of the Excel window, click the Home tab at the top of the window,

click the home tab

Then click the Insert button in the Cells section of the ribbon, and then click the Insert Sheet option.

insert, then insert sheet

Additionally, you can add a new worksheet by right-clicking any of the worksheet tabs at the bottom of the window, then selecting the Insert option.

right-click tab, then click insert

Select the Worksheet icon,

click the worksheet icon

Then click the OK button.

click the OK button

Finally, you can also insert a new worksheet by pressing the Shift + F11 keys on your keyboard at the same time.

The order of worksheet tabs can be adjusted by clicking and holding the tab at the bottom of the window, then dragging it to the desired location.

move a worksheet tab

Now that you know how to add a new worksheet in Excel 2010 you can start to take advantage of the simplicity that can come with keeping multiple spreadsheets within the same file.

Are you finding it difficult to work with the default worksheet names in Excel? Read this article and learn how to change the name of a worksheet to something that is more useful.

Join Our Free Newsletter

Featured guides and deals

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