ms excel training - creating absolute references

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Creating absolute references

ms excel training - Creating absolute references

resolvedResolved · Low Priority · Version Standard

Creating absolute references

what other ways are there to create absolute references other than using $?

RE: creating absolute references

Aisling,

You wan use the F4 key to enter the reference for you.
There are 4 settings - 1 relative, 2 mixed and one absolute.

Simply place your cursor on the cell reference you want to change, and press F4.

Example:
$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:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips


Server loaded in 0.08 secs.