Add and format tables and charts

Sort table contents

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Tip: Video not in your language? Try selecting Closed Captioning Closed captioning button .

When your table contains data that would be better presented in alphabetical or numerical order, sort it.

  1. Select anywhere in the table.

  2. Select Table Tools Layout > Sort.

    Note: In Excel, select Home > Sort & Filter > Custom Sort.

  3. Choose your sorting criteria.

  4. To choose a sort order, select Ascending or Descending.

  5. To sort on a second column, enter that information for Then by.

    Note: In Excel, select Add Level and then enter the information. The second level sort only takes effect if two or more values in the first column are the same.

  6. If your table has a header row, select Header row or My data has headers and then select OK.

Tip: In Excel, to sort A–Z, Z–A, lowest to highest, or highest to lowest, select a cell in the column to sort by, select Sort & Filter, and then select a sort option.

Want more?

Sort the contents of a table

Word training

PowerPoint training

Excel training

Outlook training

If you’re working with data in a table, sort it to best present your content.

To sort data in Word, select anywhere in the table and select Table Tools Layout.

And then select Sort.

Now choose your sorting criteria.

To put your data in Ascending order and keep the header row at the top of the table, make sure that Header row is selected.

And then select OK.

To sort a column in Excel, select it, select Sort & Filter, and then select how you’d like to order it.

You can also select Custom Sort, and then select your sort criteria.

To set additional filters, select Add Level.

Expand your 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.

×