One way would be to Save the file, then Save As to another name. In the Save
As file, highlight everything and copy, then Edit, Paste Special, Values.
This replaces the formulas with the value (not to worry - your formulas are
in the Saved file).
Then you can sort your columns and get the outcome you are looking for.

CaroleO



"Michele" wrote:

I have a worksheet that I sort one way for data entry and another way for
printing. In the spreadsheet, I have a column that I update every two weeks.
The column has a total; but below it, there is another formula that takes
the total and subtracts the various cells above that are not eligible. When
I go to sort it for printing, the formula's value changes. How do I get the
various cells listed in the formula to change when I sort? i.e. the cell is
X3 when I'm doing my data entry and verifying totals, but when I sort it for
printing, it is now X9 and the formula is still looking at cell X3.
--
Michele