Small grey squares will appear in the column headers.Ĭlick the small square from the column you want to alphabetize, and select Sort A to Z.You will need to change the format of that cell to Wrap Text, and you might have to change the row height as this does not always adjust automatically. If this post is helpful or answers the question, please mark it so, thank you. Make sure Expand the selection is the chosen option.Ī second method to sort and alphabetize is to apply a filter. Re: Put the lines in a cell into alphabetical order. Hi, highlight the range to be sorted, then in the ribbon go to Data,sort,choose the column to be sorted by, then click ok.Click the drop down menu and select Sort A to Z.In an excel spreadsheet, find and highlight the column you want to alphabetize.
Whether you’re sorting through an attendance list for a recent webinar, or need to organize your inventory from A to Z, you’ll memorize these steps faster than you learned the alphabet.Ībove is a video demonstrating two different methods for alphabetizing columns and below are the listed steps.
With the click of a button, you’re able to sort and alphabetize any column you please.
0 kommentar(er)
