Forum Discussion
consecutive page numbers für printing with portraot and landscape format
Hello everyone,
I have already found out how to set consecutive page numbers on several worksheets in an Excel sheet for printing. My current problem is that the first tab is in portrait format and the second tab is in landscape format, so that both tabs are currently displayed in portrait format in the consecutive numbering.
Does anyone have any idea how I can have the first 2 pages from the first tab printed in portrait format and the 3rd page from the 2nd tab printed in landscape format?
Best regards,
Lukas
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.
