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

ms excel training - creating absolute references

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

ms excel training - Creating absolute references

ResolvedVersion 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

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

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.