Can I switch axes in a Worksheet?

  • Thread starter Thread starter Amy Sheller
  • Start date Start date
A

Amy Sheller

Can I switch axes in a Worksheet? It was easier to enter
data in the current setup but now it may be easier to
analyze the data if I can switch the axes. Can it be
done??
 
Excellent! thanks!!
-----Original Message-----
Amy

Can you Copy>Paste Special>Transpose to a new worksheet?

If you have more than 256 rows you cannot Transpose the rows to columns.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
Click to expand...
 
Back
Top