microsoft-excel-courses - Range Naming

Resolved · Low Priority · Version Standard

Mon 20 Nov 2006, 17:08 Delegate Janet said...

Janet has attended:
Excel Intermediate course
Word Intermediate course

Range Naming

Can you name a range?

Mon 20 Nov 2006, 22:02 Trainer Martin said...

RE: Range Naming

Hi Janet,

Yes select the cells you want and then either type the name into the "Name Box" or go to Insert / Name / Define. Any problems let us know.
Regards
Martin

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips