ms excel courses - How does absolute cell referencing work?

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

Resolved · Low Priority · Version Standard

How does absolute cell referencing work?

Sarah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course

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

Thanks

Sarah

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: How does absolute cell referencing work?

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

Hi Sarah,

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

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Courses Teach Advanced Macro Techniques
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Benefits of learning about Excel charts
· How to Create Better Excel Spreadsheets: Part Four