P Pete_UK Jan 11, 2008 #2 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
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
S ShaneDevenshire Jan 11, 2008 #3 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.
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.
G Gord Dibben Jan 11, 2008 #4 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
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