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

microsoft excel course - absolute cell referencing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Absolute cell referencing

microsoft excel course - Absolute cell referencing

ResolvedVersion Standard

Absolute cell referencing

how does this work?

thanks

anne

RE: absolute cell referencing

Hi Anne,

A relative cell reference in a formula, such as A1, is based on a relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed.

An absolute cell reference in a formula, such as $A$1, will always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same.

Hope that helps Tracy

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.