Tabs Titles to incorporate into worksheet

I would like to have my tab in excel show up on a title inside the Excel page Can I refer to it so it automatically shows when I create the tab.?

Excel for web

Patrick2788

Silver Contributor

Jan 28, 2020

Marc-Charlebois

Enjoy:

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

GADarrah

Copper Contributor

Sep 20, 2020

Patrick2788 This formula inserts the ACTIVE sheet name. So if I have sheets "List1" and "List2" and I type that formula into cell C17 in "List1" it will return List1. But if I go to sheet "List2" and do some work, it changes cell C17 in "List1" to List2, because "List2" is now the Active Sheet. I have 10 sheets and I put that formula in each one of them - and each one changes whenever I go to any of the other sheets and do anything that makes the worksheet recalculate. So if I have "List 1" "List2" "List3" etc. up to "List10" and have that formula in cell C17 of each sheet, they ALL show the name of the Active Sheet. So for example, if I go to "List5" and add a formula in cell D53, then C17 in ALL TEN of the sheets change to List5.

I want a LIST of all 10 of the sheet names on another of my sheets, (which will reference to the sheet name in each of the "List" sheets) but if I do some work in "List4" then my list becomes:

List4

etc. - instead of what I want, which is:

List1

List2

List3

etc.

I need something that keeps the sheet name for THAT sheet, not the sheet name for the Active Sheet. And I need my list to change when I change any of the sheet names.

Any ideas?

Thanks!

SergeiBaklan
Diamond Contributor
Sep 21, 2020
GADarrah

Please add the reference on any cell in formula, like

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,40)
- GADarrah
  Copper Contributor
  Sep 21, 2020
  SergeiBaklan - EXCELLENT!! This is the final fix that I needed. Thanks so much!
  - SergeiBaklan
    Diamond Contributor
    Sep 21, 2020
    GADarrah , you are welcome

Forum Discussion

Tabs Titles to incorporate into worksheet

Resources