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.Make sure Expand the selection is the chosen option.Ī second method to sort and alphabetize is to apply a filter.Click the drop down menu and select Sort A to Z. In an excel spreadsheet, find and highlight the column you want to alphabetize.All you have to do now is to press ‘Ok’ There are some things worth noting here. Then you can either select Ascending Alphabetical Order (A to Z) or Descending Alphabetical Order (Z to A). 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. The one we want is alphabetic order, so simply in the ‘Sort By’ text box choose ‘Text’ in the ‘Type’ box. With the click of a button, you’re able to sort and alphabetize any column you please.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |