Undo Sort Error

[Guest]

Hi I hope someone can help with this.
I have a spreadsheet that is shared and someone sorted it by the first row
only. now all the info is basically useless. is there a way to fix this and
prevent sorting just by colums. Oh yes who ever did this saved the
spreadsheet and "undo" is not possible.

Help ! Please

 

[Dave Peterson]

I think that the only way you can reverse this is to do it manually--or maybe
restore from a backup version???

If I remember correctly, xl2002 added a warning if you tried to sort a
multicolumn range with only a single column selected. ("Do you want to expand
the selection or sort just that single column?" kind of prompt.)

One way to try to stop the user from sorting by a single column is to make it
easier to sort the data.

You could give the users some buttons on the worksheet to sort by a specific
key(s).

Or you could use this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html

It might make it easy enough so the users don't even use other methods to sort.