Sorting has nothing to do with relative vs absolute addresses.

Tell us what you're trying to do. There has to be a better way than manually
entering the dollar signs.

--
Regards,
Fred


"Mike" wrote in message
...
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