View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul
 
Posts: n/a
Default changing relative to absolute

Hello

I have a lot of functions in which there are relatative reference ranges, is
there a n easier way change them to absolute other than selecting each cell
individually and hitting F4?. Like can I select a range of cells and press a
button and those cells change to absolute