Forum Discussion

Marc-Charlebois's avatar
Marc-Charlebois
Copper Contributor
Jan 28, 2020

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
mathetes's avatar
mathetes
Silver Contributor
Jan 28, 2020
Is this for use in the process of printing? If so, there's a way to do that in Page...Setup, in the header or footer. If that's not it, come back with a more complete explanation, and maybe even a sample worksheet. But give the bigger context for the request.
Marc-Charlebois's avatar
Marc-Charlebois
Copper Contributor
Jan 28, 2020

mathetes 

No it is actually for the purpose of Identifying the Worksheets for my R & D so that my  worksheets carry the same title as the project and therefor the  tabs.

 

I usually have 8 to 16 different tabs , So I only want to write the title name once ..either in the spreadsheet or on the TAB .

THanks

 

 

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jan 28, 2020

    Marc-Charlebois 

    Interesting. I'm not able to find a Function that would do this. I did try SHEET and can think of a way you could use that along with VLOOKUP but it would involve more work (and may not be as reliable) as biting the bullet and, you know, writing it twice.

     

    It's entirely possible that there could be a VBA routine developed, but again, it seems to me (and I'm not a VBA person) like using a bazooka to kill a mosquito.

     

    Let's see what others can come up with.

Resources