Need help putting sort order back

[ismegordo]

Hi there all,

I am new at this. And will possibly muck up my explanation of what
need help with.

Anyway here goes:
In Excel XP I have a list of peoples names, addresses, phone number
etc..

Now we kept on adding people to the list as new people turned up, i
was then we though it would be a better idea if we put them i
Alphabetical order, So we pressed the sort button in Ascending order o
the peoples last name and that worked great and so we save the file
believing we had accomplished the task, but when we went to retrieve
persons email address we noticed that it was wrong.
ie.. We looked for John Smith and the email address came up a
jim.brown.isp.com.au for example


So is there away of getting the list back in its original order an
then how do we perform this task correctly.

Any help would be appreciated.

And Thanks in advance for any help.
Ismegord

Attachment filename: animation7.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=49740

 

[JE McGimpsey]

Unfortunately, unless you have a backup somewhere, there's no way to
recover the original sort order.

In the future, remove the sort buttons from the toolbar, and use
Data/Sort..., which will default to sorting the whole contiguous range
around the activecell, rather than just one column.