In the Home tab - editing, open Sort & Filter
and select custom sort
.
Select options and chose Sort Left to Right
This may vary to Office versions, but the steps are similar.
If you give me your version of Office, I will update my answer with the steps accordingly.