How to Rename an Excel Worksheet
By default, worksheets are labeled "Sheet 1," "Sheet 2," and so on. Especially if you're using many worksheets, it really helps to label them something more specific ("Marketing Budget," "Engineering Budget," and so on, for example). These steps work for Excel 97.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Excel and the file you want to change.
-
2
Double-click on the tab for the worksheet that you want to rename. (The tabs are at the bottom of the Excel window.) The sheet's name becomes highlighted.
-
-
3
Type in the new worksheet name.
-
4
Press Enter to accept the changes.
-
1
Tips & Warnings
Open the Edit menu and select Undo to delete the change, or just type in a new name.
Worksheet names are especially important when you send your workbook file to others who might not understand your thought processes.
Resources
More Like This
Comments
-
There is not a shortcut to rename all the worksheets in Excel. Actually getting another available tool to deal with it may be a good idea. I Found an excel add-in Kutools for Excel, which helps to rename multiple sheets by one or two click. So fast and simple. Meanwhile, it is a collection of tools that will deal with some repetitive work in Excel. Save so much time in working. I like it.
-
is important to me using an excel worksheet.
-
yogeshraykar15
Sep 03, 2010
i want to know shortkey for rename sheet in excel
