excel courses - How does absolute cell referencing work?

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

Resolved · Low Priority · Version Standard

How does absolute cell referencing work?

Dee has attended:
Word Introduction course
Excel Introduction course
Outlook Introduction course

by - delegate Dee [4 posts] (2007 Jul 4 Wed, 12:57) Reply

All the best,
Dee

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: How does absolute cell referencing work?

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 5 Thu, 10:32) Reply

Hiya Dee,

A relative cell reference in a formula, such as A1, is based on a relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed.

An absolute cell reference in a formula, such as $A$1, will always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same.

Hope that helps Tracy

· Customized Financial Excel Courses in London
· Database Tips from an Excel Training Course
· What's Better Than the Help Function in Excel? Microsoft Training
· Microsoft Excel Training Course
· Excel Macros for the Non-Programmer

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips