This article may be out of date!
Visit the New Knowledge Center

How to Sort a Table in Excel


  • n/a


  • Excel

Additional Information:

  • n/a


  1. Open the file in Excel
  2. Select the Home ribbon
  3. Choose Format as Table
  4. Select a formatting option
  5. Check the box beside My table has headers
  6. Click OK
  7. Click on the dropdown arrow that appears at the top of the table and Sort A-Z or Z-A


Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality