Problem
What do you do if one of the pages in a report is set up in landscape layout, while all the other pages are set up in portrait layout? When all the pages are combined into a single report, the page number that should be at the bottom of the landscape page will not be printed at the bottom, but at the right side (the footer of a page that is printed in landscape layout).
Solution
Print the page number from a cell in the sheet, not in the footer.
Example: A Profit and Loss Statement has 13 columns (A:M). The Profit and Loss Statement is part of a report with a large number of pages in portrait layout, but the Profit and Loss Statement is in landscape layout.
The result - the page number, 5, is displayed horizontally and centered in Column A. Screenshot // Printing page number in the opposite direction in landscape layout page in Microsoft Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
I am printing reports in both portrait and lanscape from the same workbook on pre printed stationery with a pre printed margin on the rhs of the page. When the report is then bound the portrait pages read ok but the landscape pages are 'upside down'. when printed to plain paper that is ok as I can turn them around but when printed on my stock paper, they are not usable. Does anyone know how to change landscape print outs so that the page orientation is the other way around - a difficult concept to explain by email perhaps.