Absolute References Across Cells

[MJaspering]

Hey All,

I am looking for some help to see if is possible to fill absolute references across a series. Let's say I have the following data:

=A2/A1

=B2/B1

=C2/C1

=D2/D1

=E2/E1

I then use F4 to make the second part of the initial formula an absolute reference.

=A2/$A$1

=B2/B1

=C2/C1

=D2/D1

=E2/E1

Is there a way to make the second part of each other cell (or selection) in the row an absolute reference as well so that I end up with the below? Can this be performed down cells in a column as well?

=A2/$A$1

=B2/$B$1

=C2/$C$1

=D2/$D$1

=E2/$E$1

 

[bebo021999]

1) highlight A to E
2) Ctrl-H (Find And Replace)
Finf what: /
Replace with: /$
3) Ctrl-H (Find And Replace)
Finf what: 1
Replace with: $1