I would like to have one sheet that would have the header and footer
information that would be placed on ever sheets that I print in that
workbook. I would also like it to have page# of #pages. The other problem is
that it exceeds the 255 characters to be placed in the header or footer. Does
anyone have any good ideas? Thanks! Jeff

Group your worksheets first.
Adjust the header/footer (all the sheets in the group will get that same
header/footer).

(Ungroup when you're done--anything you do to one sheet, you do to all in the
group.)

Before you print, group the sheets that should be printed.

Or file|print|Print what: Entire workbook.

===

The only workaround I know for the number of characters is to print the
header/footers using another program (MSWord???). Then send the paper through
the printer when you print your excel data.

Jeff wrote:

I would like to have one sheet that would have the header and footer
information that would be placed on ever sheets that I print in that
workbook. I would also like it to have page# of #pages. The other problem is
that it exceeds the 255 characters to be placed in the header or footer. Does
anyone have any good ideas? Thanks! Jeff

--

Dave Peterson