Excel, sort alphabetically?
Solved
Th!erry
Posted messages
770
Status
Membre
-
EUGENIE40 Posted messages 4 Status Membre -
EUGENIE40 Posted messages 4 Status Membre -
Hello
I'm presenting my little problem.
I created a directory in Excel containing all my friends' phone numbers and other useful services.
I simply made 2 columns, one on the left with the contact's first and last name and one on the right where I put the corresponding phone number.
So far, so good, but the little problem is that as I add more, they are not sorted alphabetically.
That is to say, if I add a number right away whose name starts with an "A", it will simply be placed at the end. They are therefore sorted by "date" of addition, which is not very practical when the list starts to get a bit long, as everything is mixed up.
Is there a way to sort them alphabetically automatically as I add contacts?
Thank you in advance
Thierry
Configuration: Windows XP
Internet Explorer 8.0
I'm presenting my little problem.
I created a directory in Excel containing all my friends' phone numbers and other useful services.
I simply made 2 columns, one on the left with the contact's first and last name and one on the right where I put the corresponding phone number.
So far, so good, but the little problem is that as I add more, they are not sorted alphabetically.
That is to say, if I add a number right away whose name starts with an "A", it will simply be placed at the end. They are therefore sorted by "date" of addition, which is not very practical when the list starts to get a bit long, as everything is mixed up.
Is there a way to sort them alphabetically automatically as I add contacts?
Thank you in advance
Thierry
Configuration: Windows XP
Internet Explorer 8.0