Sort Columns Article For Free

Sort the table Select a cell within the data. Select Home > Sort & Filter. Or, select Data > Sort. Select an option: Sort A to Z - sorts the selected column in an ascending order. Sort Z to A - sorts the selected column in a descending order.

Sort by several columns Click the Sort button on the Data tab or Custom Sort on the Home tab to open the Sort dialog. Then click the Add Level button as many times as many columns you want to use for sorting: From the "Sort by" and "Then by" dropdown lists, select the columns by which you want to sort your data.

Sort by Multiple Columns Select the cell range you want to sort. Select Data on the menu bar. Select Sort range. (Optional) Check the Data has header row check box. Select the first column you want to sort by and select a sort order. Click Add another sort column to sort by additional columns. Click Sort.

Select a cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, under Column, in the Sort by or Then by box, select the column that you want to sort by a custom list.

General Sort Click into any cell in the COLUMN you want to sort by within your list. (DO NOT highlight that column as this will sort that column only and leave the rest of your data where it is.) Click on the DATA tab. Click on either the Sort Ascending or Sort Descending. button.

Try it! Select anywhere in the table. Select Table Tools Layout > Sort. Choose your sort criteria: Select the column you want to Sort by. To sort on a second column, select Then by and select another column. Select Ascending or Descending. To keep the header row at the top of the table, select Header row. Select OK.

Sort quickly and easily Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click. to perform an ascending sort (from A to Z, or smallest number to largest). Click. to perform a descending sort (from Z to A, or largest number to smallest).