View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default absolute reference

I have entered a formula in a cell and have copied it to several other
adjacent cells. Now I want to change all the formulas to absolute references
so I can sort the list. How can I change a group of cells all at once rather
than editing each cell and adding the $'s.

Mike