Changing the X Y coordinates...

[Michael McClendon]

I have already entered thirteen different columns of
information with twelve rows of categories. The problem
is that I want to reverse my rows and columns to add ease
and clarity to my spread sheet. Is there a way to do this
within Excel, or do I have to just re-enter everything
into another spread sheet?

Thanks for the help,
Michael McClendon

 

[Gord Dibben]

Michael

Copy>Paste Special>Transpose.

Pick a cell outside the current range of data for your copy to insertion
point.

When all looks fine, delete original range of data.

Gord Dibben Excel MVP