Reorder column headings alphabetically?

[Rockymtnhigh]

I have a data set contained in columns A1-FA1. Column headings are in row 1 and are arranged in no special order. Is it possible to reorder columns alphabetically beginning A1 left to right? Number of rows will vary.

Thanks,

Rocky

 

[Gary McMaster]

Hi Rocky,

In the "Sort" dialog box, click "Options..." and select the "Sort Left to Right" radio button.

Gary

 

[Rockymtnhigh]

Thanks, Gary. The answer is so simple when one knows the billion nuances of Excel!

 

[Gary McMaster]

I've never actually used that for real work. I happened to notice it one day, tried it once to see how it behaved and wondered if I would ever need it.

Glad it worked for you.

Gary