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

How to Sort a Table in Excel

Objective:

  • n/a

Environment:

  • Excel

Additional Information:

  • n/a

Procedure:

  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