List

B

brianwakin

I created a list that sorts multiple columns with formulas in them. I am
trying to eliminate get rid of blank cells and numerically sort the cells
using a list. My problem is I can't unsort the list after sorting if
necessary. In some cases I may need to put the formulas back in their
correct cells in order to add more data. How can I put the values back in
their original cells before sorting them? Any help would be appreciated.
Thanks.
 
G

Gary's Student

What you are describing is very frustrating. What I do is to insert a help
column containing 1,2,3,4,.... down the column. I sort this column along
with the others. If I ever want to go back to the original order, I sort by
the helper column to get back to 1,2,3,4,...

The only alternative I have found to to start pumping the un-do button and
pray.
 
Top