How to create and rename a worksheet in Microsoft Excel

In Microsoft Excel, you can add one or more worksheets to an Excel spreadsheet file, as well as rename the worksheet to whatever you want to name it.

Add new worksheet

To add a new worksheet to your Excel file, follow the steps below for the version of Excel on your computer.

Excel 2013 and later

1. At the bottom of the Excel window, to the right of the last worksheet listed, click on the + symbol.
2. A new worksheet will be created, with a default name of “Sheet” plus a number. The number used is the number of existing worksheets plus one. For example, if there are three worksheets in the Excel file, the new worksheet will be named “Sheet4”.

Excel 2010 and earlier

1. At the bottom of the Excel window, to the right of the last worksheet listed, click the small tab with a folder-like icon and star at the upper left corner.
2. A new worksheet will be created, with a default name of “Sheet” plus a number. The number used is the number of existing worksheets plus one. For example, if there are three worksheets in the Excel file, the new worksheet will be named “Sheet4”.

Rename worksheet

To rename a worksheet in an Excel file, follow the steps below.

1. At the bottom of the Excel window, right-click on the worksheet tab you want to rename.
2. Type in the new name for the worksheet and press Enter.

Note: There is a 31 character limit for a worksheet name.