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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Want to sort by formula value without losing formula 4
Sorting with Column has Formula 3
Sorting and Formulas 1
Inserting new rows, which contain the formula in the above the new 5
Sorting and formula reference 5
Ascending Sort formula, change to neg #: descending sort.. 6
Sort using formula 15
Excel Help to copy information from one row at a time to another sheet 1

Back
Top