Printing sheet name

[deymongussman]

Hi:

Can someone tell me how to print a sheet name when I print a worksheet.


Deymon

 

[fairwinds]

Hi,

You can choose View - Header and footer and choose to add the sheetname in the header or footer.

 

[deymongussman]

Hi

Not quite what I was looking for. I have a workbook with 150 worksheets and this would not work.

Daymon

 

[fairwinds]

Just select all sheets first, and then do as above you will get each sheet name at each sheet.

 

[deymongussman]

Fairwinds:

Excellent. Thanks for your help

Deymon

 

[2rrs]

One way:
enter in a cell of your choice:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))