Home » Blogs » Nick's blog

98. Excel Tips - Sort Columns

Nick's picture
Submitted by Nick on 2 February, 2010 - 16:12

Excel Tips - Sort Columns (Excel 2007)



We all know how to sort rows, but did you also know that you can sort columns ?

Here's a screen shot of our data in Excel:

sort-columns

And here's what happens when we sort columns:

sort-columns

- NOTE that the columns are now sorted alphabetically.

Here's how

  1. Select your data
  2. From your ribbon, click Data
  3. Select Sort
  4. Choose Options
  5. Select "Left to Right"

    • sort-columns

  6. Choose the row to sort by

 

 

Download sheet to practise how to Sort Columns in Excel

Training Video on how to Sort Columns in Excel:

AttachmentSize
sort-columns.xls533.5 KB
»

thanks for the article

Submitted by Anonymous on 23 December, 2011 - 16:10.

thanks for the article. It helped me a lot and saved my time

»