How do I aphabetize a Row

I just typed in 107 headings into row 1. Each heading is in a separate column, but I need to put ROW 1 in alphabetical order. selecting the row and using sort ascending does not work.

Select your row. Then go to Data->Sort chose Options tab & change Direction at bottom of dialog (Left to Right). Then to Sort Criteria tab & Sort Key 1 use dropdown to select the row you highlighted. Select OK button. Should be sorted.

Thanks. I had complete brain failure on this one :frowning:

I’ve Been there many times! Happy to help.