Rename a worksheet

Rename a worksheet

By default, Excel names worksheets Sheet1, Sheet2, Sheet3 and so on, but you can easily rename them.

Image of Excel worksheet tabs

3 ways to rename a worksheet

  1. Double-click the sheet tab, and type the new name.

  2. Right-click the sheet tab, click Rename, and type the new name.

  3. 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 Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Insert or delete a worksheet

Video: Move or copy worksheets

Quick start: Print a worksheet

Group worksheets

Protect a worksheet

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×