ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing (https://www.excelbanter.com/excel-discussion-misc-queries/230112-printing.html)

del

Printing
 
When printing a huge worksheet, how do I force the page break to go
horizontally as opposed to going vertically. Example:
The order of the pagebreak of my current spread sheet goes this way:

page 1 page 2 page 3

page 4 page 5 page 6

page 7 page 8 page 9

I want it to go this way:

page 1 page 4 page 7

page 2 page 5 page 8

page 3 page 6 page 9

thanks,
del


Gord Dibben

Printing
 
In Page SetupSheet look at the options of "down, then over" and "over, then
down"


Gord Dibben MS Excel MVP

On Thu, 7 May 2009 09:33:01 -0700, del
wrote:

When printing a huge worksheet, how do I force the page break to go
horizontally as opposed to going vertically. Example:
The order of the pagebreak of my current spread sheet goes this way:

page 1 page 2 page 3

page 4 page 5 page 6

page 7 page 8 page 9

I want it to go this way:

page 1 page 4 page 7

page 2 page 5 page 8

page 3 page 6 page 9

thanks,
del



del

Printing
 
Thanks a lot!!!

"Gord Dibben" wrote:

In Page SetupSheet look at the options of "down, then over" and "over, then
down"


Gord Dibben MS Excel MVP

On Thu, 7 May 2009 09:33:01 -0700, del
wrote:

When printing a huge worksheet, how do I force the page break to go
horizontally as opposed to going vertically. Example:
The order of the pagebreak of my current spread sheet goes this way:

page 1 page 2 page 3

page 4 page 5 page 6

page 7 page 8 page 9

I want it to go this way:

page 1 page 4 page 7

page 2 page 5 page 8

page 3 page 6 page 9

thanks,
del





All times are GMT +1. The time now is 08:36 AM.

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