#1   Report Post  
Posted to microsoft.public.excel.misc
del del is offline
external usenet poster
 
Posts: 16
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
del del is offline
external usenet poster
 
Posts: 16
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Printing Roger Excel Discussion (Misc queries) 4 March 21st 07 09:51 PM
printing E-QUIP Excel Discussion (Misc queries) 2 January 10th 07 08:59 PM
Printing a heading on each new page when printing Brian Excel Discussion (Misc queries) 3 November 15th 06 05:22 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"