How do I undo a sort?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Teresa - 23 May 2008 14:54 GMT

Hi,

I sorted a column A to Z in a very large spreadsheet and saved the file, but
I wish to cancel the sort. Is there any way I can do this?

Thanks,
Teresa

Reply to this Message

Bob I - 23 May 2008 15:02 GMT

Not after you saved it, time to pull out the backup files and reload it.

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks,
> Teresa

Reply to this Message

Bernie Deitrick - 23 May 2008 15:05 GMT

Teresa,

Once you have saved it, you cannot use undo, since that clears the undo stack. But you can simply
re-sort it on other columns - there is no loss of data, and whatever functionality you have should
survive the sort.

HTH,
Bernie
MS Excel MVP

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks,
> Teresa

Reply to this Message

Bob I - 23 May 2008 16:12 GMT

I read the issue as a SINGLE column was selected and sorted, basically
destroying the spreadsheet.

> Teresa,
>
[quoted text clipped - 13 lines]
>>Thanks,
>>Teresa

Reply to this Message