Unsorting

A

Amy Ilene

I have a very extensive chart that I keep breaking down, sorting, adding, and
so forth. Is there a way that when I am done doing what I need, to return to
the original way it was when I first started?
 
B

Bob Umlas

1 - re-open the file?
2 - before sorting, enter 1, 2, 3,... on a column. When done with your
manipulations, sort by this column & it'll be back in 1, 2, 3... order,
a.k.a. original.
 
A

Amy Ilene

So I shoudl just insert a new row on top and label each column with a number,
then when I am done sort by those columns?
 
D

David McRitchie

Amy,
No, that is not what was meant.
Insert a new column, on the first row place a 1, then
drag the fill handle down so the row 2 in the column gets a 2
row 3 gets a three, etc. You must not use a formula as that
would defeat the purpose of being able to sort things back
to the original order.
http://www.mvps.org/dmcritchie/excel/fillhand.htm

The word "No" may be a little harsh if English is not your
native language, but you can't mix up rows and columns in
Excel and be understood.

If you actually were sorting within a row, you would have to
sort each row one at a time (in macro, preferably) and you
would not be able to restore the manner by a simple adaptation
of the instructions.

HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top