Module 4 | Excel | Sheet Tab Naming
Naming Sheet Tabs in Excel
By default, Excel names worksheets Sheet1, Sheet2, Sheet 3, and so on, but you can easily rename them. Sheet names in an Excel file should be unique and provide information about what can be found on the worksheet. Any blank sheets in a workbook should be deleted.
Worksheet names cannot:
- Be blank
- Contain more than 31 characters
- Contain any of the following characters: / \ ? * : [ ]
- Begin or end with an apostrophe, but they can be used in between text or numbers in a name
- Be named "History." This is a reserved word Excel uses internally
Three Ways to Rename a Worksheet
- Double-click the sheet tab at the bottom of the document and type the new name.
- Right-click the sheet tab at the bottom of the document, select Rename, and type the new name.
- Use the keyboard shortcut Alt+H > O > R, and type the new name.
Video Tutorial (1:50)
Resources