If the rows are already absolute
do a replace A$ with $A$ for all of the columns you wnay to make absolute
then do a replace $$ with $ in case any oif the columns were already absolute.

"BorisS" wrote:

> can I quickly find/replace all non existent absolute references (for
> different column letters), and replace them with absolute versions of that
> letter? Each different column reference, however, is matched with the same
> absolute reference to row (if that helps). In other words, I don't want to
> replace with the same thing, but rather I want the sheet to go through the
> logic of "when I find the references of f$16 and g$16, I should replace them
> with $f$16 and $g$16".
>
> Thanks.
> --
> Boris