how to print the worksheet name somewhere on the printed page ?

  • Thread starter Thread starter Simo Sentissi
  • Start date Start date
S

Simo Sentissi

Hello there

I was wondering how to print the worksheet name somewhere on the printed
page ?

Thanks
 
Simo Sentissi said:
Hello there

I was wondering how to print the worksheet name somewhere on the printed
page ?

Thanks
Click to expand...

Page Setup | Header/Footer | Custom Footer and enter &[file] in whichever
part of the footer required. You can also press the 'excel' button

Peter
 
If you want the worksheet name, use the &[Tab] code. &[File] gives the
workbook name. There are buttons there that will put these codes wherever
the cursor currently is in the header or footer. You just have to figure
out which button is which. They'll make that more apparent in a few years.
--
Earl Kiosterud
www.smokeylake.com

Peter Andrews said:
Simo Sentissi said:
Hello there

I was wondering how to print the worksheet name somewhere on the printed
page ?

Thanks
Click to expand...

Page Setup | Header/Footer | Custom Footer and enter &[file] in whichever
part of the footer required. You can also press the 'excel' button

Peter
Click to expand...
 
You must log in or register to reply here.

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

Epson XP-3150 not printing 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA - Problem with Closing Print Preview 0
Excel won't print 2
Excel Fit to page print options in Excel 1
Excel 2007 print option gone 1
Print macro that hides rows before printing 1
Print preview doesn't show all of the workbook pages to print in 2007 2

Back
Top