Cell references

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

Resolved · Low Priority · Version Standard

Cell references

Sophie has attended:
Excel Introduction course

by - delegate Sophie [1 post] (2008 Feb 27 Wed, 16:33) Reply

could you tell me more about absolute cell references

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
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	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: cell references

by - trainer Rich platinum contributer [711 posts] (2008 Mar 1 Sat, 10:31) Reply

They are used when you do not want the reference of a field to change even when you drag down a formula or copy it to another cell. For example:

=SUM(C9+G12)

If you drag this formula down to the cell below it will change to the following formula:

=SUM(C10+G13)

It will automatically add one. A, absolute cell reference stops this automatic incrementation. If you put an absolute cell reference as follows:

=SUM(C9+$G$12)

This will continue to increment the C9 part but the G12 field will always be the same.

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How to Create Better Excel Spreadsheets: Part Three
· How to check for and reduce errors in Microsoft Excel
· Fun Things I've Done With Excel
· How to Create Better Excel Spreadsheets: Part One

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips