Sorting columns alphabetically

  • Thread starter Thread starter SueG
  • Start date Start date
S

SueG

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?
 
SueG said:
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?
Click to expand...

Select your range. Select Data / Sort / Options and under Orientation select
"sort left to right".
 
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
 
Back
Top