Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Excel 2007

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training onsite - Excel 2007

Resolved · Low Priority · Version Standard

Reply Mon 17 Sep 2007, 14:35Delegate Dionne said...

Dionne has attended:
Excel Introduction course
Powerpoint Introduction course
Word Intermediate course

Excel 2007

what's the difference between relative and absolute references?

For upcoming training course dates see: Pricing & availability

Reply Mon 1 Oct 2007, 14:04Trainer Amanda said...

RE: Excel 2007

Hi Dionne

Thank you for your question.

Relative and absolute references are cell references in a formula.

A relative cell reference changes when a formula is moved or copied to another location in your spreadsheet. By default, cell references in a formula will be relative unless you make them into an absolute reference.

An absolute cell reference does not change when a formula is moved or copied to another location in your spreadsheet. An absolute reference is recognisable in a formula as it has $ signs preceding the column letter and the row number in the cell reference, e.g. $B$4.

I hope this helps.
Amanda
Amanda

Excel articles

· Why Printing Needn't Be A Grey Area In Excel
· How To Create A Custom List In Excel
· Improve Performance Of Your Excel Macros
· How To Create A Multiple Pie Chart In Excel
· Using Headers And Footers In Excel 2010

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips