Sorting columns alphabetically
 

I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through row
108 with the corresponding name. Is that possible?

Sorting columns alphabetically
 

SueG wrote:
I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through row
108 with the corresponding name. Is that possible?

Select your range. Select Data / Sort / Options and under Orientation select
"sort left to right".

Sorting columns alphabetically
 

Thank you very much!!!!

"Glenn" wrote:

SueG wrote:
I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through row
108 with the corresponding name. Is that possible?

Select your range. Select Data / Sort / Options and under Orientation select
"sort left to right".

Sorting columns alphabetically
 

Hi

copy range B2:DH108, in an unused sheet select A1, goto "Edit" Paste
Special Check "Transpose" OK Sort the range.

Now repeat the steps above to paste the sorted data into the original place.

Hopes it helps.

Regards,
Per

"SueG" skrev i meddelelsen
...
I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through
row
108 with the corresponding name. Is that possible?