Change name of tab sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The 'help' menu tells me to double click on the tab sheet and override the name. When I do this, nothing happens!
(e-mail address removed)
 
Hello,

Double-clicking should highlight the sheet name, allowing
you to change it just be typing. If you can't get it to
work, try right-clicking on the sheet name, and selecting
rename from the menu. If that doesn't work, the worksheet
is probably protected. Choose Tools, Protect, from the
menu bar, and see if there is a menu option "Unprotect
Sheet". If so, the sheet is protected. If is
says "Protect Sheet", then your worksheet is unprotected
and you should be able to rename it.

Bob Sullivan
Springhouse
-----Original Message-----
The 'help' menu tells me to double click on the tab
Click to expand...
sheet and override the name. When I do this, nothing
happens!
 
I think Bob meant that the workbook may be protected (if you can't rename the
worksheet).

I've always been able to rename protected worksheets--if the workbook's
structure isn't protected.

It's also under Tools|Protection|Protect Workbook (or Unprotect workbook).

(and to Don--are you sure you're on the worksheet tab at the bottom of the
worksheet? If you're still having trouble, you can use Format|sheet|Rename,
too.)
 
Back
Top