How do I sort the columns of an Excel spreadsheet? The Sort
command from the Data
menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents of a specific row.
How can I do this?
microsoft excelsortingspreadsheet
How do I sort the columns of an Excel spreadsheet? The Sort
command from the Data
menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents of a specific row.
How can I do this?
Best Answer
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.