Answer: To apply this sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen. Then click on the Sort button and select Custom Sort from the popup menu. When the Sort window appears, select the first column that you wish to sort. I'm trying to alphabetize a list of names in a word document in Word for MAC 2008? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
. Select all of the cells that you want to sort by alphabetizing two or more lists in the range. Select Data on the toolbar and choose Sort.
The Sort dialog box will open. Select the primary column by which you want to alphabetize the data in the Sort By box and select Ascending.
Choose the second column by which you want to sort the range of cells in the Then By list. You can sort by up to three columns. Select the Header Row radio button if your list has a header at the top. Click OK to sort the list alphabetically. Select all of the cells that you want to sort by alphabetizing two or more lists in the range. Click Sort & Filter in the Editing section of the Home tab.
Select Custom Sort. A Sort dialog box will open. Select the My Data Has Headers check box if your lists have a headers at the top. Select the primary column by which you want to alphabetize the data in the Sort By box.
Choose Cell Values in the Sort On box. Select A to Z in the Order box. Click the Add Level button at the top of the dialog box. Select the second column by which you want to alphabetize the data in the Sort By box. Choose Cell Values in the Sort On box.
Select A to Z in the Order box. Click Add Level to sort by another column, if desired. Click OK when you are ready to alphabetize your table.