Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
  1. Select the table. After you select it, the Table Design and Layout tabs will appear.

  2. Next to Table Design, go to Layout > Sort.

    Sort button when you have a table selected

  3. In the dialog box, choose how you’d like to sort the table.

    Sort dialog box

    1. Choose whether data has headers or not.

    2. Under Sort by, choose the name or column number to sort by.

    3. Under Type, choose Text, Number, or a Date.

    4. Select Ascending or Descending order.

  4. Repeat for up to three levels.

  5. Select Options for additional settings, such as case sensitive, sort language, and if you have delimited information.

  6. Select OK.

  • Select the table. After you select it, the Table Design and Layout tabs will appear.

  • Next to Table Design, go to Layout > Sort.

    Table Layout tab with the Sort option highlighted.

  • In the dialog box, choose how you’d like to sort the table.

    Shows the options you can set in the Sort dialog box.

    1. Select the Header row if the data has headers.

    2. Under Sort by, choose the name or column number to sort by.

    3. Under Type, choose Text, Number, or a Date.

    4. Select Ascending or Descending order.

  • Repeat for up to three levels under Then by.

  • Select Options for additional settings, such as case sensitive, sort language, and if you have delimited information.

Classic Ribbon 

  1. Select the table. After you select it, the Table Design and Layout tabs will appear.

  2. Select Table Layout.

  3. In the Data section, select Sort Table Ascending or Sort Table Descending depending on how you want to sort your table.

    test

Single Line Ribbon 

  1. Select the table. After you select it, the Table tab will appear.

  2. Select the Sort option under the Table tab.

  3. Click on the dropdown menu next to Sort option and select Sort table Ascending or Sort Table Descending depending on how you want to sort your table columns content.

    Table tab with the Sort option highlighted.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×