Printing landscape worksheets with footer on left

[Guest]

I know that I must not be the first person to have this problem, but I cannot
find a solution.

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, 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!

 

[Dave Peterson]

Any chance you can print the footers separately--then reload the paper through
the printer?

 

[Guest]

No, we need to send the report electronically to our print shop, and it also
needs to be put online. (I don't know how that will be done, though)

 

[Dave Peterson]

Maybe you could import your workbook (or even pictures of your data) into
another application that supports this.

But I don't have any idea if there is such a monster.

Maybe your print shop will have a suggestion--this is a pretty frequent
question.