How do I sort data in excel which was created by formulas?

N

Nathan

I have a list of information that is created using formulas. I want the
information to update whenever I make changes in the excel spreadsheet, so I
want to keep the formulas (I do not want to do a paste special and choose
"values"). I want to be able to sort the information in an ascending order.
When I do this all of the formulas change. Is there a way to keep the
formulas constant so that it only refrences those cells chosen before a sort?
 
Top