How to succesfully sort column of formulas?

[evemonkey]

I am trying to sort a column of formulas that consist of cel
references. Example:

Column:
Cell 1 holds: =D10
Cell 2 holds: =D11
Cell 3 holds: =D12

Data:
D10=1
D11=2
D12=3

When I try to sort the column of formulas, the formulas change cel
references to other cells and mess up the data.

How can I sort a column of cells of which all of them contain formula
and have the cells keep the references to the right place

 

[ElsiePOA]

Hi-

If you write your formulae with absolute references rather tha
relative references, you can sort them. Formulae should look lik
=$D$1