page setup landscape, but print footer in portrait mode

[Guest]

I have several pages that are being compiled. Most of them are printed in a
portrait mode, but several are in landscape. I would like to print page
numbers on all of them in the lower right hand corner. The landscaped pages
will be turned facing the right of course, so the page number needs to print
in the left hand margin turned 90 degrees.

 

[Frank Kabel]

Hi
not possible without VBA. You may record a macro while
- set the page layout for the first pages
- print these pages
- change the page layout (landscape)
- print these pages

 

[swatsp0p]

Is there any way to put these different 'pages' on separate sheets i
the workbook? It is possible to print multiple sheets with mixe
layouts (format each sheet as desired), allowing the footer to prin
correctly on each sheet.

Just a thought.

Bruc

 

[Frank Kabel]

Hi
no, not possible (there's no 'section break' in Excel as it is
available in MS Word)

 

[Guest]

Thanks for your insight. The question still remains, however, as to how to
turn the footer printing 90 degrees from the body.

 

[Guest]

Thanks for your input. As I replied to Frank, though, I'm not sure how to
turn the footer 90 degrees to the body.

 

[swatsp0p]

Let's make sure we are talking about the same thing. You say several
"pages". Do you mean one worksheet that prints over multiple pages...
or a workbook that has several worksheets you need to print?

If you have the latter, it is easy to format each "sheet" to print
either portrait or landscape, and the footers (and headers, too) will
be properly formatted to fit the selected style.

If you have just one sheet that prints on multiple pages, there is no
way to do a single format step to accomplish your desired outcome.
Frank's suggestion of printing one "page" at a time and formatting each
page prior to printing is the only way available. (doing this once with
the macro recorder will then allow you to repeat the task by running the
macro).

My suggestion was to break the single worksheet into multiple
worksheets (cut and paste?) to facilitate differring page layouts and
format each page accordingly. I have a workbook with 50+ sheets. Some
are Portrait, some are Landscape, and some are Landscape Legal size. A
"Print Workbook" command prints the entire 50+ pages, each in the
proper format and on the proper size paper, with Headers and Footers
correctly oriented.

HTH

Bruce

 

[Guest]

Let's say you are preparing a financial statement presentation with all the
pages letter sized but some are printed with a portrait orientation and some
are landscaped. You will put all the pages in the binder in the standard
portrait presentation. The pages that are printed in landscape will be
turned 90 degrees counter-clockwise to match the other pages for binding.
The page numbers for those printed with a portrait mode will be lower right
hand relative to printing on the page and relative to the binder. The
landscape printed pages (that are no bound in a standard 3-ring binder) will
be have the footer - relative to the printing on the page - in the lower
right hand, but - relative to the binding - it will be twisted up to the
upper right hand and facing outwards. My desire is to have all the footers
be presented (relative to the binder) in the same lower right hand corner.
This would require that, on the landscaped printed pages, The "footer" would
actually be on the left hand side facing outward relative to the body.

Sorry this seems to be getting so complicated. I've being using Excel for a
very long time and don't ever seem to have been troubled by this question
before so I don't want to be a PITA by belaboring this point.

TFTH
Mark

 

[swatsp0p]

Mark: I now understand your dilema and, I'm afraid, I know of no
workaround. As I indicated, my multipage report also had mixed
orientations. My thought process was the reader would need to rotate the
binder to read the landscape pages anyway, so might as well have the page
numbers in the same orientation on that page.

If someone has a magical solution (other than pre-printing page numbers on
blank pages then rerunning those sheets through the printer), I'm confident
they will share it with us all.

Good Luck,

Bruce

 

[Guest]

I have submitted a suggestion to microsoft. I have not submitted a
suggestion before, but at least its a shot...

Please see:

Suggestion for printing landscape spreadsheets in book orientation

and click I agree (if you do)
dcraig

 

[Guest]

I've done a work-around for this by adding a column to the left, inserting
the number of the page and formatting it to rotate it clockwise..... Not a
very computer-literate method but it beats (slightly) running prenumbered
pages thru the copier.