Thread: changing from relative to absolute cell reference in multiple form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAaron
 
Posts: n/a
Default changing from relative to absolute cell reference in multiple form
Is there a way to change relative cell refernces in multiple formulas from
relative to absolute all at the same time, rather than highlighting refernce
and hitting F4 and changing them one at a time. I have to change several
hundred formula references from relative to absolute.
Reply With QuoteReply With Quote