reverse columns and rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have decided that my rows and columns should be reversed, for printing. Is
there a way to print this out so that they are in reverse or do I need to
manually change everthing within my spreadsheet?
 
Hi Teri. I'm afraid you have to change everything. But, it's straight
forward.
Copy your data, select the first blank column in Row A and do Edit>Paste
Special>Transpose and then delete the original data columns. Also, if you
just want to do it for printing, you could use a blank spreadsheet for the
pasting. HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to invert Cols/Rows? 2
Column labels show as numbers and Row labels show as numbers 3
How do I reverse the order of a column or row? 3
Reverse columns in Excel 2007 1
Change from columns to rows and back 3
Why are my columns and rows reversed when I open Excel 1
how paste transpose reverse? 2
reversing text within cells 1

Back
Top