How do I print the name of a tab on an Excel document?

[Guest]

I am trying to have the words on a tab print on the finished document - can
this be done?

 

[Guest]

In xl2003 for sure and I would suspect in xl2002 at least, that is an option
under a custom header or footer under View =>Header and Footer.

 

[Gord Dibben]

Where would you like the Tab name to be printed?

As a header/footer? In a cell? On every printed page?


Gord Dibben MS Excel MVP

 

[Guest]

If you do not want this in the header/footer, then try inputting the
following in a cell:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

But there is a slight issue with this - as you browse through every tab,
this does not update itself unless you actuall do something on that tab.

e.g. I have 12 sheets labelled jan, feb, mar, ..., dec.
i've got cell A1 that says "Report for jan", "Report for Feb" etc.. in all
the sheets

now if i'm looking at jan, its fine... but whne i go to feb, its still
showing jan until i actually do something like enter data on feb's sheet...
this updates feb correctly, but at the same time, changes all the A1 values
in all the sheets to feb as well....

I haven't tried printing all the sheets at one go to see if that works
alright.

Hope this helps somewhat! Perhaps a MVP can add something?!

problem is - when i browse to jan's sheet, it says jan correctly
but when i browse to feb's sheet, this also seems to say feb.

 

[David McRitchie]

I think the original poster wanted the solution that Tom Ogilvy gave
for the title on the page. it will print on each page and was certainly
available back in Excel 95.

As for the use of the CELL formula with filename it fails because
you did not provide a reference cell. See
http://www.mvps.org/dmcritchie/excel/pathname.htm
and a formula that will provide the sheet tab name is
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

If you do not want this in the header/footer, then try inputting the
following in a cell:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

But there is a slight issue with this - as you browse through every tab,
this does not update itself unless you actuall do something on that tab.

e.g. I have 12 sheets labelled jan, feb, mar, ..., dec.
i've got cell A1 that says "Report for jan", "Report for Feb" etc.. in all
the sheets

now if i'm looking at jan, its fine... but whne i go to feb, its still
showing jan until i actually do something like enter data on feb's sheet...
this updates feb correctly, but at the same time, changes all the A1 values
in all the sheets to feb as well....

I haven't tried printing all the sheets at one go to see if that works
alright.

Hope this helps somewhat! Perhaps a MVP can add something?!

problem is - when i browse to jan's sheet, it says jan correctly
but when i browse to feb's sheet, this also seems to say feb.

I am trying to have the words on a tab print on the finished document - can
this be done?

 

[Guest]

Thanks - that's helped me fix one of the quirkier things that have been
annoying me in recent times.

I think the original poster wanted the solution that Tom Ogilvy gave
for the title on the page. it will print on each page and was certainly
available back in Excel 95.

As for the use of the CELL formula with filename it fails because
you did not provide a reference cell. See
http://www.mvps.org/dmcritchie/excel/pathname.htm
and a formula that will provide the sheet tab name is
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

If you do not want this in the header/footer, then try inputting the
following in a cell:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

But there is a slight issue with this - as you browse through every tab,
this does not update itself unless you actuall do something on that tab.

e.g. I have 12 sheets labelled jan, feb, mar, ..., dec.
i've got cell A1 that says "Report for jan", "Report for Feb" etc.. in all
the sheets

now if i'm looking at jan, its fine... but whne i go to feb, its still
showing jan until i actually do something like enter data on feb's sheet...
this updates feb correctly, but at the same time, changes all the A1 values
in all the sheets to feb as well....

I haven't tried printing all the sheets at one go to see if that works
alright.

Hope this helps somewhat! Perhaps a MVP can add something?!

problem is - when i browse to jan's sheet, it says jan correctly
but when i browse to feb's sheet, this also seems to say feb.

I am trying to have the words on a tab print on the finished document - can
this be done?