Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 More...Less
By default, Excel names worksheets Sheet1, Sheet2, Sheet3 and so on, but you can easily rename them.
3 ways to rename a worksheet
-
Double-click the sheet tab, and type the new name.
-
Right-click the sheet tab, click Rename, and type the new name.
-
Use the keyboard shortcut Alt+H > O > R, and type the new name.
Important: Worksheet names cannot:
-
Be blank .
-
Contain more than 31 characters.
-
Contain any of the following characters: / \ ? * : [ ]
For example, 02/17/2016 would not be a valid worksheet name, but 02-17-2016 would work fine.
-
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.
Rename a workbook
If you want to rename a workbook, first locate it in Windows Explorer, then you can press F2, or right-click and select Rename, then type the new name.
If your workbook is already open, then you can go to File > Save As to save the workbook with a different name. This will create a copy of the existing workbook.
Need more help?
You can always ask an expert in the Excel Tech Communityor get support inCommunities.
See Also
Video: Move or copy worksheets
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
