Aisling has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel Introduction course
Excel Intermediate course
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