ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   reverse columns and rows (https://www.excelbanter.com/excel-discussion-misc-queries/40136-reverse-columns-rows.html)

Teri from Florida

reverse columns and rows
 
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?

Michael

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 EditPaste
SpecialTranspose 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
--
Sincerely, Michael Colvin


"Teri from Florida" wrote:

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?



All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com