ProTip: you can sort a row of cells with the same commands as a column of cells. Use this for sorting column headers.
This one’s obvious once you’ve seen it but typically sorting is viewed as going down a column. You can force Excel to sort cells horizontally as well. From the
Sort menu, hit the options in the upper right, and then choose
Move Horizontally. This will then give the choices down below using labels like
Row 1 and
Row 2 instead of the normal
Column A and
Column B. This can be used to simply sort cells horizontally or to reorder columns by sorting. It’s more intuitive to think of sorting down a column, but just remember you can perform as the same operations transposed.
This technique is useful enough that I’ve create a simple macro which does it from a button click. The only downside to hormonal sorting is that Excel requires several clicks to do it.