excel training courses - Absolute referencing

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

Resolved · Low Priority · Version Standard

Absolute referencing

Kate has attended:
Excel Introduction course

by - delegate Kate [1 post] (2006 Nov 29 Wed, 16:39) Reply

Is it safest to always put in the dollar signs before every column and row reference or can that sometimes goes wrong?

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

RE: Absolute referencing

by - trainer Amanda platinum contributer [947 posts] (2006 Nov 29 Wed, 22:14) Reply

Hi Kate

Thanks for your question.

You do not need to make every cell in a formula into an absolute reference (the name for a cell that has $ before the column letter and row number), you only need to do this when you need a specific cell in your formula to remain constant/the same in order to get the correct formula result.

Most of the time leaving your formula how it is without making an cells into an absolute reference works fine.

Amanda

· Benefits of learning about Excel charts
· A Beginners Guide To Formulas In Excel
· How Excel Training Can Improve Your Company's Sales Process
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Reasons Why VBA for Excel Training Fails