Suggestion for printing landscape spreadsheets in book orientation

D

dcraig

I know that I am not the first person to have this problem, but noone can
find a solution. Hopefully, Microsoft can get the hint...

Please set up a process to print worksheets that are formatted as landscape
to have the footer on the "left" side, so when a report is put together for
printing all of the footers are on the bottom of the page.

This is a previous discussion I had, (one of many from other users)
concerning this subject:

I have a workbook that has 20 worksheets. The orientation varies between
portrait and landscape. I need the landscape worksheets to print with the
footer on the "left" side, so that when I put the entire report (workbook)
together for presentation, all of the footers are on the bottom, like a book.

I have tried merging the first column (A) and making it the footer with the
font facing left, but it is difficult to make them print evenly on each
sheet.

I have also tried to copy and transpose the worksheet and change the font to
face right, but when it pastes,the right column becomes the bottom row and it
is tedious to rearrange everything for some of these complex schedules.

Any help is appreciated!
 
Top