Data naming

The UK's most regular instructor-led training courses.
Training information: excel+courses · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyThu 2 Jul 2009, 16:06Delegate Carol said...

Carol has attended:
Excel Advanced course

Data naming

How do you assign a name to a page

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	1		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

635 posts

ReplyFri 3 Jul 2009, 09:25Trainer Carlos said...

RE: Data naming

Hi Carol

I take from your question that you want to change the name of the whole sheet. To do this:

1. Double click the tab whose name you want to change OR

2. Right click on the tab and select Rename

3. The name is highlighted.

4. Enter the new name and press Enter

Hope this helps

Carlos

Thu 9 Jul 2009: Automatically marked as resolved.

· Data Basics Using Excel
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Utilise the web's information banks with Microsoft Excel
· Tips From Excel's 'Rarely Used' File
· Excel Charts As Easy As Pie

Please browse our web site to find out more about
excel+courses and other Microsoft training courses.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips