sorting excel table as originally created

northernsoul

Hi
I have an excel table. I have names in my first column and recently i sorted them in order of the names ie Alan, barry, colin etc. I now want to put back in the order i created them. eg for my 3 examples, i might have had Barry,s details first, in row 1, then Alan on row 2 , then colin etc etc.
Is there some properties i could access for each time i put a new name in. I would then create a column 'date created'

Of course it would be nice if i could somehow sort back to date i created each person automatically.

Thanks in advance

debitcardmayhem

In a new column press ctrl ; (semicolon) (won't help for original dates though)

bluesnake

if you have sorted without making changes after, you could press undo

if you have saved before the sort, you could close the sheet down without saving again.

other than that none I can think of. All you can now do is sort by column. Next time just a a column that counts up, so you are able to put it back to the original sort order

debitcardmayhem

Create a copy first, then in windows explorer , right click on the file --> properties --> previous versions it may be in a restore point ...

northernsoul

Thanks for the last suggestion, i have a previous version so will use that. Thought there were properties somewhere!