Undoing after saving

[Steve]

I have a list of names that is in chronological order.
Sometimes, to find a name, we sort the list by
alphabetical order, find the name, then hit "undo". The
list goes back to normal and we save and close.

We accidentally hit save while the list was sorted in
alphabetical order and now can't undo it to its proper
place. Is there anything I can do? Thanks very much.

Steve Anderson

 

[Frank Kabel]

Hi Steve
sorry, no chance (unless you have a backup)

 

[Thrava]

Why cna't you re-sort ? if you have a field (column) that
has the dates in, you could just sort by date.. to give
you back the chronological order.

 

[Dave Peterson]

I'm guessing that you have multiple rows per record and that doing another sort
impossible.

This won't help you this time, but you may want to add a column with row numbers
in them.

put 1 in A1
and 2 in A2
Select A1&A2 and use the autofill button to drag it down your range.

Then you can sort by anything and resort by this original row number column.
(remember to resequence the rows if you add any).

Another option that may eliminate the Sort problem altogether.

Select your range (top left cell to bottom right cell) and do
Data|filter|autofilter.

You can use those dropdowns to hide/show what you want.

There's even a Custom option where you can specify lots of stuff: Begins with,
does not begin with, contains...

 

[vikesh]

mr. dave peterson u r right on target