consecutive page numbers für printing with portraot and landscape format

Lukas233 

There are a few ways to achieve consecutive page numbering for printing with different page orientations in your Excel sheets:

1. Manual Page Breaks and Section Breaks:

• Insert Page Break: Insert a page break at the end of the first tab (before the second tab).
• Insert Section Break: In the second tab, before the content you want in landscape, insert a Section Break (Next Page).
• Set Page Orientation: Go to "Page Layout" -> "Orientation" and choose "Landscape" for the second section.
• Set Page Numbers: Go to "Insert" -> "Header & Footer" (or "Page Number" depending on your version).
• Format Page Numbers: Choose "Format Page Numbers" and set "Start at" to "1" for the second section to ensure consecutive numbering.

2. Use VBA Macro (Optional):

This method requires creating a macro, which can be more technical but automates the process. You can find tutorials online for creating macros to set page breaks, section breaks, and page numbering based on specific conditions.

3. Print Separately (Last Resort):

• If the above methods seem complex, you can print each tab separately.
• Go to "File" -> "Print".
• Choose the specific sheet you want to print in the "Print Settings" section.
• Set the desired page orientation in the "Settings" section.

Additional Tips:

• Always preview your print settings before printing to ensure the page breaks and numbering are as intended.
• If you frequently work with mixed-format workbooks, consider using templates with pre-defined page breaks and section breaks for different tabs.

By implementing one of these methods, you should be able to achieve consecutive page numbering with different page orientations in your Excel sheets for printing.