Editing multiple cells at the same time

[Darren]

Example:
Column A contains a list of numbers 5, 10, 15 and 20 in cells 1-4
In A6 i write =(A1)
then copy it down to A9 to repeat the sequence.
Now, if I try to transpose the list all the values change.
I would like to know how, if possible, can I change them all together making
them absolute values so they would read
=$A$1
=$A$2
=$A$3
=$A$4
without doing them 1 at a time.

 

[Gary''s Student]

Use FIND/REPLACE

Find:
A
Replace with:
$A$
Replace All

 

[Darren]

Thankyou very much.

Use FIND/REPLACE

Find:
A
Replace with:
$A$
Replace All