Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013

Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets are called “worksheets” and can be navigated by clicking a tab at the bottom of the spreadsheet.

You might already be familiar with worksheets, and have maybe even figured out how to create new ones. But the default naming structure for worksheets in Excel can be a little vague, so you might be looking for a way to describe them a little better with a name name.

Fortunately our guide below can show you how to name a worksheet something other than Sheet1, Sheet2, Sheet3, etc.

How to Use a Custom Worksheet Name in Excel 2013

The steps in this article were performed in Microsoft Excel 2013. Note that updating the name of a worksheet will automatically update the references in any formulas that include the previous name of the worksheet, so your formulas should continue to function correctly.

Step 1: Open your Excel file in Excel 2013.

Step 2: Locate the worksheet tabs at the bottom of the window.

worksheet tabs in excel 2013

Step 3: Right-click the worksheet that you want to rename, then select the Rename option.

rename worksheet

Type the new name for the worksheet, then press Enter on your keyboard.

how give worksheet different name excel 2013

Now that you know how to give a worksheet a custom name in Excel 2013, you can make it much easier to identify the different worksheet tabs that you have in your workbooks.

Do you have a lot of worksheets in Excel, and you would like to get rid of some of them, but aren’t ready to delete them? Learn how to hide worksheets in Excel 2013 so that you still keep the data, but the worksheet tabs themselves aren’t visible at the bottom of the spreadsheet.

Join Our Free Newsletter

Featured guides and deals

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