Converting anchored from unanchored?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have cells that have references, such as C12 or D12, and I want to change
them to anchored, $C$12 or $D$12. Is there a shortcut key I can push if I
select all those cells I want to convert? I don't want to have to type in
all those $. I am using Excel 2000. An earlier post said to click F4 but it
only redid my last action, inserting a cell.

Please help! Thanks.
 
I guess what I meant to ask is changing from relative to absolute values. I
figured out how to do it cell by cell but is there a way to do it for a range
of cells at one time??
 
Back
Top