How to sort an Excel spreadsheet columns by row contents?

Solution 1:

It's a custom sort in the Data sorting.

From the Data tab click on the Sort button to open the Sort dialog box, click on Options to open the Sort Options dialog box and select Sort left to right. See here for more info.

sort by row steps