Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to unsort my excel columns after save changes?
If I save changes to the excel file after sorting, I can't able to unsort it
as original. Is there any option to do so in excel? |
#2
|
|||
|
|||
You cannot undo the sort after saving. The best to do before sorting, is to
add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column. "RAFFI" wrote: If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? |
#3
|
|||
|
|||
Hi
As sorting in Excel means overwriting all data in new order - definitely no! The only option is undo - which doesn't help you after you saved the file. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "RAFFI" wrote in message ... If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? |
#4
|
|||
|
|||
RAFFI Wrote: If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? Hi Raffi Before sorting add an additional column numbered 1 - ?, you can the re-sort on that column -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=476144 |
#5
|
|||
|
|||
"Joy" wrote: You cannot undo the sort after saving. The best to do before sorting, is to add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column. "RAFFI" wrote: If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? |
#6
|
|||
|
|||
"Joy" wrote: You cannot undo the sort after saving. The best to do before sorting, is to add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column. "RAFFI" wrote: If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? |
#7
|
|||
|
|||
"RAFFI" wrote: "Joy" wrote: You cannot undo the sort after saving. The best to do before sorting, is to add an ID column with numbers running from 1. Then if you want to restore your sort, you can then sort on this column. "RAFFI" wrote: If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? |
#8
|
|||
|
|||
"Arvi Laanemets" wrote: Hi As sorting in Excel means overwriting all data in new order - definitely no! The only option is undo - which doesn't help you after you saved the file. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "RAFFI" wrote in message ... If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? Thank you for your reply, But I thought that there couldl be an index file that can be attached with the original file or any other supporting key file would generate simultaneoustly when we sort a columnn. thanks |
#9
|
|||
|
|||
Hi
Excel is a spreadsheet, not a database. There is no indexing built in - you can look at it as at a (selection of) big unstructured 2-dimesional table(s) (you can implement your own pseudo-structure of-course). It's strong side is calculating many formulas simultanously, and extreme design flexibility. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "RAFFI" wrote in message ... "Arvi Laanemets" wrote: Hi As sorting in Excel means overwriting all data in new order - definitely no! The only option is undo - which doesn't help you after you saved the file. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "RAFFI" wrote in message ... If I save changes to the excel file after sorting, I can't able to unsort it as original. Is there any option to do so in excel? Thank you for your reply, But I thought that there couldl be an index file that can be attached with the original file or any other supporting key file would generate simultaneoustly when we sort a columnn. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
save excel file formatted as f12.3 | Excel Discussion (Misc queries) | |||
How do I unhide columns after clicking save? | Excel Worksheet Functions | |||
Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) | |||
Excel crashing on save as | Excel Discussion (Misc queries) |