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