Naming working sheets

  • Thread starter Thread starter james
  • Start date Start date
Double-click on the worksheet tab and the existing name will be
highlighted - just type a new name for that sheet and press <enter>
when you've done.

Hope this helps.

Pete
 
Hi,

In 2003 or earlier:

1. Choose the command Format, Sheet, Rename
2. Right-click the sheet tab and choose Rename
3. (Best) Double-click the sheet tab and type in the name

In 2007
1. Home, Format, Rename Sheet
2. same as 2 above
3. same as 3 above.

There is no shortcut key for this command.
 
If you want a VBA solution post back with a sample of what names you would like
for your sheets.


Gord Dibben MS Excel MVP
 
Back
Top