Printing Worksheet Name

  • Thread starter Thread starter steph
  • Start date Start date
S

steph

HELP!

Is there a way to print the worksheet name on each page
when printing an entire workbook with multiple worksheets?

Thanks in advance,
Steph
 
View>Header and Footer>Custom Header (or Footer)>enter "&[File]" without
quotes in the section...right, left, or center...where you want the file
name.
 
You could put it in the header or footer.

File|page setup|header/footer
custom header (or footer)

There's an icon that looks like a worksheet. If you click it, it'll insert
&[Tab] into which ever section you're modifying.
 
Back
Top