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.
- Select Column A (see the screen shot).
- Right-click, and from the shortcut menu, select Insert.
- In Cell A1, type the number 5 (assuming that 5 is the number of the page in the report).
- Select the range A1:A29.
- Press Ctrl+1 (Format Cells).
- Select the Alignment tab.
- In Text Alignment, Horizontal, select Left (in Excel 97, select Right). In Text Alignment, Vertical, select Center.
- In Text Control, select Merge cells.
- In Orientation, change the text orientation to -90 degrees (if the sheet direction is right to left, text orientation should be 90 degrees).
- Click OK.
- Update the print area - from the File menu, select Page Setup.
- Select the Sheet tab.
- In Print Area, change B1 to A1. The new print area is A1:N29 (the print area includes the new column).
- Select the Margins tab.
- Reduce the right margin to 0 (so that the page number will appear at the bottom of the printed page).
- Select the Header/Footer tab.
- Select Custom footer.
- Delete Page (if it appears in one of the sections).
- Click OK.