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
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.
Did you know that there is a quick way to eliminate errors in you Excel spreadsheets?