microsoft-excel-courses - Range Naming

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

Resolved · Low Priority · Version Standard

Range Naming

Janet has attended:
Excel Intermediate course

by - delegate Janet [1 post] (2006 Nov 20 Mon, 17:08) Reply

Can you name a range?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Range Naming

by - trainer Martin bronze contributer [27 posts] (2006 Nov 20 Mon, 22:02) Reply

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

· What's Better Than the Help Function in Excel? Microsoft Training
· Identifying Suitable Candidates For VBA For Excel Training
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel Training Course

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips