Forum Discussion
database of names
G'day, extremely novice excel user here. I have a practice client record database here. After I add new names how do I make them appear in the correct alphabetical order instead of just appearing as ...
Hi Bazza1966,
What you want to do here is select the arrow next to "Surname" and select "Sort A to Z".
I suggest you remove the spreadsheet from your post, lots of confidential data in here.
Ben
In addition to the menu selection for sorting, there's available in the newest versions of Excel a SORT function, which could be used dynamically to sort by last name, by city, by zip code...whatever.
And to underscore what Bennadeau has said, I'm asking the board moderators to remove your posted sheet, in case you don't get to it first. For future reference, the good practice here is to always remove real names and other confidential information from any sample sheet.