I would like to alternate footer layout in an Excel document. Is this possible?

If you are printing multiple pages from a single worksheet, the answer is NO,
unfortunately. If you have one printed page per worksheet, you can manually
set up a footer for each sheet, and alternate from one worksheet to the next.
It's quite a bit of trouble, though

"Bee" wrote:

I would like to alternate footer layout in an Excel document. Is this possible?

You could use VBA code to print your alternate footers.

See Ron de Bruin's site for code.

http://www.rondebruin.nl/print.htm#Header

Adjust to suit.


Gord Dibben MS Excel MVP

On Tue, 13 Mar 2007 22:06:03 -0700, Bee wrote:

I would like to alternate footer layout in an Excel document. Is this possible?

With such advanced technology today, Excel should already have this function
- or so one would think! I'm hoping Microsoft will develop this function as
it will save me hours of work!

"Duke Carey" wrote:

If you are printing multiple pages from a single worksheet, the answer is NO,
unfortunately. If you have one printed page per worksheet, you can manually
set up a footer for each sheet, and alternate from one worksheet to the next.
It's quite a bit of trouble, though

"Bee" wrote:

I would like to alternate footer layout in an Excel document. Is this possible?