microsoft excel courses - How does absolute cell references work?

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

How does absolute cell references work?

Aminata has attended:
Excel Introduction course
Excel Intermediate course

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

Cheers,

Hazel

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 14 Tue	Bloomsbury	0	FULL
2002/XP	2008 Oct 14 Tue	Tooting	0	FULL
2003	2008 Oct 16 Thu	Southwark	5	book now	£198	£215
2002/XP	2008 Oct 21 Tue	Tooting	0	FULL
2003	2008 Oct 21 Tue	Bayswater	4	book now	£195	£205
2003	2008 Oct 23 Thu	Bloomsbury	1	book now	£215	£215
Full Schedule: See all 125 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: How does absolute cell references work?

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

Hi Aminata,

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

· Benefits of learning about Excel charts
· Microsoft Excel Training: Not Just for Newbies Anymore
· How to Create Better Excel Spreadsheets: Part Two
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training - Numerical excellence for all

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips