Archive for October, 2014

Sort horizontally in Excel

Did you know you can sort horizontally  (left to right or right to left) in excel? I didn’t until a few days ago and I wish I knew this a long time ago.

How to sort columns by the contents of a particular row:

  1. Select the range you wish to sort
  2. Click the Data tab > Sort & Filter section > Sort
  3. Click Options
  4. Under Orientation choose Sort left to right

This allowed me to sort a set of columns by their name in the first row, and then sort by the total of that column again later to show the highest totals together.