show sheet tab label in a cell on the sheet?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
is it possible to display the name of a sheet in a cell on that sheet?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,530
Office Version
  1. 365
Platform
  1. Windows
How about
=TRIM(RIGHT(SUBSTITUTE(CELL("filename"),"]",REPT(" ",100)),100))
or
=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,100)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,530
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388

ADVERTISEMENT

something not quite right. I'm using this on 12 sheets (jan to dec) in cell A1 on each sheet. When i copy and paste your formula into each sheet, although it shows that sheet's name in A1 it also shows the same thing in the other 11 sheets? e.g. i paste it into A1 on the june sheet and all the sheets jan to dec now also show june in their A1 cell.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,530
Office Version
  1. 365
Platform
  1. Windows
Missed the cell Ref, which ever formula your using, change
CELL("filename")
to
CELL("filename",A1)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,530
Office Version
  1. 365
Platform
  1. Windows
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,109,331
Messages
5,528,052
Members
409,800
Latest member
camronmartin

This Week's Hot Topics

Top