Absolute reference formulas

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

Resolved · Low Priority · Version 2003

Barbara has attended:
Excel Introduction course

by - delegate Barbara [1 post] (2008 May 12 Mon, 16:32) Reply

How do you lock a reference formula?

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: absolute reference formulas

by - trainer Tracy platinum contributer [586 posts] (2008 May 13 Tue, 05:48) Reply

Hi Barbara,
To answer your question to lock a formula you have to make it absolute by putting dollar signs around the reference. For example A1 becomes $A$1. A shortcut to this is clicking into the reference and pressing the function key F4.
Hope that helps
Tracy

· What's Better Than the Help Function in Excel? Microsoft Training
· Tips to Facilitate Printing of Excel worksheets
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Office and the Small Business: Part 1 Excel
· How to Create Better Excel Spreadsheets: Part Two

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

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips