Absolute reference

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Can anybody tell me how I can absolute a range of cells.
i.e. instead of pressing F4 in each cell, I can just
highlight a group and make them all $[x]$[1]. Thanks
 
Hi Anna,

You can do it via a Macro, or download a free utility, ASAP Utilities
(download from www.asap-utilities.com), which provides this functionality.

If you decide to go down the Macro route,
http://support.microsoft.com/default.aspx?scid=kb;en-us;70096&Product=xlw
should help.

If you go with ASAP Utilities, go to ASAP-Utilities-->Formula-->Change
Reference Style (ie A1 to $A$1 etc). From there you can select your range
and then select whether to change from A1 to $A$1, $A1, A$1.

HTH,
Katherine
 
Back
Top