Once you have entered data into a table, you can reorganize it in alphabetical or numerical order from the Sort dialog box. For example, you may want to sort a list of customers alphabetically by last name or numerically by sales. Excel allows you to sort by in either ascending (A to Z for alphabetical data, smallest to largest for numbers and oldest to most recent for date) or descending (Z to A for alphabetical data, largest to smallest for numbers and most recent to oldest for dates) order.
Word allows you to sort by up to three levels. To sort a table, click the Sort button on the Data group of the contextual Layout Ribbon and choose the columns by which you wish to sort.
To Sort a Table by Multiple Columns
- Activate any cell within your table.
- Click the contextual Layout tab on the Ribbon.
- Click the Sort button on the Data group.
- Select the field by which you want to sort in the Sort By drop-down list.
- Click the Type arrow and choose the data content type.
- Click the Ascending or Descending radio button.
- Click the Header Row or No Header Row as it applies.
- Click OK when finished.
Similar Posts:
- None Found
Comments on this entry are closed.