Sort the contents of a table
-
Click inside the table to show Table Tools in the ribbon, and then click Layout > Sort.
You'll see the Sort dialog box.
-
In the dialog box, choose how you'd like to sort the table.
-
Under Sort by, choose the name of the column you want to sort the table by.
-
Next to Type, choose if you'd like to sort according to Text, Number, or a Date.
-
Click next to Ascending or Descending to choose a sort order. The following table is sorted in ascending order.
-
-
When you are finished, click OK.
More options:
-
If the column you're sorting contains fields of information separated by commas, tabs, or some other character, click next to Using to choose which field to sort by. For example, if the column you're sorting is Last name, First name, you can choose to sort by Last name or First name. Click the Options button at the bottom of the dialog box to choose the separating character.
-
If you want to have a second level sort, you can enter that information under Then by. The second level sort will only take effect if two or more values in the first column are the same.
-
You can also choose a third level sort, as shown in the following table.
-
If your table has a header row, be sure to click the Header row box under My list has at the bottom of the dialog box. That way, the top row will not be sorted and will stay at the top.
-
Click Options for additional settings, such as making your sort case sensitive or choosing the sort language.
You can also sort a list that's not in a table.
See also
Convert text to a table or a table to text
No comments:
Post a Comment