database of names

%3CLINGO-SUB%20id%3D%22lingo-sub-1489224%22%20slang%3D%22en-US%22%3ERe%3A%20database%20of%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489224%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710192%22%20target%3D%22_blank%22%3E%40Bazza1966%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EWhat%20you%20want%20to%20do%20here%20is%20select%20the%20arrow%20next%20to%20%22Surname%22%20and%20select%20%22Sort%20A%20to%20Z%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_1-1593095088881.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201077i4E33B943527C0D07%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_1-1593095088881.png%22%20alt%3D%22Bennadeau_1-1593095088881.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20suggest%20you%20remove%20the%20spreadsheet%20from%20your%20post%2C%20lots%20of%20confidential%20data%20in%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BBen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489942%22%20slang%3D%22en-US%22%3ERe%3A%20database%20of%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20the%20menu%20selection%20for%20sorting%2C%20there's%20available%20in%20the%20newest%20versions%20of%20Excel%20a%20SORT%20function%2C%20which%20could%20be%20used%20dynamically%20to%20sort%20by%20last%20name%2C%20by%20city%2C%20by%20zip%20code...whatever.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20to%20underscore%20what%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%20has%20said%2C%20I'm%20asking%20the%20board%20moderators%20to%20remove%20your%20posted%20sheet%2C%20in%20case%20you%20don't%20get%20to%20it%20first.%20For%20future%20reference%2C%20the%20good%20practice%20here%20is%20to%20always%20remove%20real%20names%20and%20other%20confidential%20information%20from%20any%20sample%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489149%22%20slang%3D%22en-US%22%3Edatabase%20of%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489149%22%20slang%3D%22en-US%22%3E%3CP%3EG'day%2C%20extremely%20novice%20excel%20user%20here.%20I%20have%20a%20practice%20client%20record%20database%20here.%20After%20I%20add%20new%20names%20how%20do%20I%20make%20them%20appear%20in%20the%20correct%20alphabetical%20order%20instead%20of%20just%20appearing%20as%20the%20last%20three%20names%20added%20%3F%20As%20in%20how%20can%20I%20move%20them%20up%20the%20list%20to%20their%20correct%20position%20alphabetically%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1489149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1490023%22%20slang%3D%22en-US%22%3ERe%3A%20database%20of%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710192%22%20target%3D%22_blank%22%3E%40Bazza1966%3C%2FA%3E%26nbsp%3BAs%20per%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%2C%20we%20removed%20your%20attachment%20as%20it%20violates%20our%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fcommunity-guidelines%2Fmicrosoft-tech-community-code-of-conduct%2Fm-p%2F31390%22%20target%3D%22_self%22%3ECode%20of%20Conduct%3C%2FA%3E%20to%20disclose%20private%20or%20personal%20information%20in%20the%20community.%20Thanks%20for%20understanding.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 the last three names added ? As in how can I move them up the list to their correct position alphabetically ?

3 Replies

Hi @Bazza1966,

What you want to do here is select the arrow next to "Surname" and select "Sort A to Z". 

Bennadeau_1-1593095088881.png

I suggest you remove the spreadsheet from your post, lots of confidential data in here.

 

 Ben

@Bennadeau 

 

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.

@Bazza1966 As per @mathetes, we removed your attachment as it violates our Code of Conduct to disclose private or personal information in the community. Thanks for understanding.