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