Changing the X Y coordinates...

  • Thread starter Thread starter Michael McClendon
  • Start date Start date
M

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
 
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
 
Back
Top