Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Naming working sheets

Hi

Please can anyone help me give names to my worksheets

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Naming working sheets

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

On Jan 11, 9:38*am, james wrote:
Hi

Please can anyone help me give names to my worksheets

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default Naming working sheets

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.
--
cheers,
Shane Devenshire


"james" wrote:

Hi

Please can anyone help me give names to my worksheets

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Naming working sheets

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

On Fri, 11 Jan 2008 01:38:05 -0800, james wrote:

Hi

Please can anyone help me give names to my worksheets

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Help naming sheets jlclyde Excel Discussion (Misc queries) 8 November 20th 07 09:59 PM
Naming multiple sheets Amanda Excel Discussion (Misc queries) 2 April 24th 07 04:46 PM
Naming Sheets for day of the month Socks322 Excel Discussion (Misc queries) 0 November 7th 06 03:08 PM
Macro for naming sheets? Olle Svensson Excel Discussion (Misc queries) 1 August 3rd 06 03:41 PM


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"