R
RAFFI
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?
as original. Is there any option to do so in excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joy
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.
add an ID column with numbers running from 1. Then if you want to restore
your sort, you can then sort on this column.
A
Arvi Laanemets
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.
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.
P
Paul Sheppard
RAFFI said: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
R
RAFFI
Joy said: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.
R
RAFFI
Joy said: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.
R
RAFFI
R
RAFFI
Arvi Laanemets said: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<at>tarkon.ee )
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
A
Arvi Laanemets
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.
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.