microsoft excel courses in - absolute reference

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Absolute reference

microsoft excel courses in - Absolute reference

resolvedResolved · Low Priority · Version Standard

David has attended:
Excel Introduction course

Absolute reference

I am not sure what the absolute reference is. Is there a set way to define this?

RE: Absolute reference

Hi David,

An absolute reference is when a formula of any kind refers to an external (to itself) cell, and it ALWAYS refers to that EXACT cell no matter what.

Sometimes when you copy a cell, the reference will change. This is know as RELETIVE REFERENCING. ABSOLUTE referencing is the reverse of that.

Here are some examples:

$A$1
Both the column and row reference is fixed. Neither will be incrementd or changed during a copy or fill.

$A1
Only the column reference is fixed. It will not change during a fill or copy, but the row will change.

A$1
Only the row reference is fixed. It will not change during a fill or copy, but the column will change.

Regards

Richard

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.



View all Excel hints and tips


Server loaded in 0.08 secs.