Excel provides no way to do this. One workaround is to assess the page breaks and between each pair of page breaks paste a suitably sized picture of the side header/footer you want on the left and right sides respectively of the area to print - of course you'll need to include these 'margins' in the print area.
I am producing a reporting pack which is predominantly in landscape. However, one or two pages are in portrait, but I need the footers to be in the same place as the other sheets, so the user can scan through the bottom corner of all the pages to see their content, irrespective of whether the page is landscape or portrait orientated. I thought of transposing my report through 90 degrees, but was hoping for an easier solution!
Actually, there is no reason why the page can't be formatted sideways.
1. Create your page as a 'regular' page. No need to get a bent in your neck.
2. Start with a second, blank sheet.
3. With that blank sheet, Select All, and format as follows:
Orientation as 90 degrees anti-clockwise.
Column width (as pixels) 125% of desired font height (in pixels)
4. Copy your 'regular' page. Make note of columns and rows.
5. If you have 12 columns, move 12 rows down, and select that single row, as many columns wide as 'regular' rows height (transpose the columns and rows dimensions).
6. Right-click upon the selection, Paste Special - Transpose. (Am not sure about Transpose......)
7. How does it look? This message was edited by stevebausch on 2002-10-10 20:48
A useful way to accomplish printing the headers/footers in one page orientation and the body in another is to create a report and then have sections of it transferred to the output report by way of the camera tool. If you look to customise one of the menu options and then add in the Camera tool from the Tools menu where you want it to appear.
Highlight the data you want to drop into a new sheet, click the camera tool once setup and then click where you want it to appear and presto!