Most people are familiar with sorting top to bottom.However you can also sort from left to right. To do this is very easy.
Follow the same procedure as a normal sort:
- highlight the cells,
- Click on DATA and
- then SORT.
At this stage you must click on the OPTIONS button. Choose the left to right option (note that you can also apply case sensitivity). Choose the row you want to use and Excel will sort from left to right.