Sort a table

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

Back to previous page Go to next page

Sorting a table column gives you ways to organize your table data just the way you want.

Sorting a table

Sorting a camping supply list by the cost from highest to lowest

Ways to sort a table

  1. Position the insertion point in the column you want to sort.

  2. To toggle a Header row on or off, Choose Layout > Sort and then choose Header Row.

    If the first row is treated as a Table header, it is not sorted. Otherwise, it is sorted with the other rows.

  3. Choose Layout > Sort, and then do one of the following:

    • To sort from A-Z or 1 to 9, choose Sort Ascending.

    • To sort from Z-A or 9 to 1, choose Sort Descending.

    • To sort only certain rows, select the rows, and then choose Sort Selected Rows.

Top of module
Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.