From theSort bydrop-down list, select the row number you want to alphabetize (Row 1 in this example). In the other two boxes, the default values will do just fine, so we keep them (Cell Valuesin theSort onbox, andA to Zin theOrderbox), and click OK: As the result, the first r...
2. Select a cell in the Helper column. 3. To sort in ascending order, on the Data tab, in the Sort & Filter group, click AZ. Done. The formula ensures that the titles are sorted by the main words instead of articles (A, An, The), making the alphabetical list more intuitive and ...
Sort by the first item in a list In this example, we'll look at a list of first and last names. We're going to sort them by the first name. Step 1:To begin, select all the items in your list. Mark Coppock/Digital Trends Step 2:Select theSortbutton from theHomemenu. Image us...
Sort by the first item in a list In this example, we'll look at a list of first and last names. We're going to sort them by the first name. Step 1:To begin, select all the items in your list. Mark Coppock/Digital Trends Step 2:Select theSortbutton from theHomemenu. Image used...