Help with repeat rows for header & Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Separate lines (line break) - PowerPoint Footer 1
Headers and Footers by VBA? 6
Change Header/Footer w/ Worksheet Option Buttons 1
Update Headers & Footnotes from User Form 9
"Continued" in Header and Repeat Footers 1
To get the same header,footer and sheet titles across multiple sheetsof a workbook. 1
Header & Footer from vb6 2
Excel Unique last page footer 1

Back
Top