Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I undo a sort?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I undo a sort?
Not after you saved it, time to pull out the backup files and reload it.
Teresa wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I undo a sort?
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 "Teresa" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I undo a sort?
I read the issue as a SINGLE column was selected and sorted, basically
destroying the spreadsheet. Bernie Deitrick wrote: 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 "Teresa" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo | Excel Discussion (Misc queries) | |||
undo F11 key | Charts and Charting in Excel | |||
Undo | Excel Discussion (Misc queries) | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions |