View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TheresaP TheresaP is offline
external usenet poster
 
Posts: 1
Default how to apply absolute cell referencing to multiple cells at once?

Hi, I know that you press F4 to change the cell referencing to absolute,
relative or mixed. But is there a way to select a range of cells to apply the
change all at once instead of having to choose each one and pressing F4 for
each. Any help is greatly appreciated! Thanks!