Topics Map > Office 365 > Excel

Microsoft Excel - Renaming 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.

For more information, please visit the Excel help center.


If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at help@nmsu.edu.




Keywords:microsoft excel rename worksheet   Doc ID:74858
Owner:John B.Group:New Mexico State University
Created:2017-07-26 14:51 MDTUpdated:2017-07-26 14:51 MDT
Sites:New Mexico State University
Feedback:  2   2