Printing Worksheet Name

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
 
J

Jim

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.
 
D

Dave Peterson

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.
 
Top