Thread: Change references ALL at once
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard[_27_] Richard[_27_] is offline
external usenet poster
  
Posts: 1
Default Change references ALL at once
Is there a way to select a group of cells and change all of the cell references from RELATIVE to
ABSOLUTE. I tried F4 but that just changes the cell format.

TIA,

Richard
Reply With QuoteReply With Quote