Ask Experts Questions for FREE Help !
Ask
    yellowjacket83's Avatar
    yellowjacket83 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 1, 2009, 07:44 AM
    Excel Sheet Tab Links
    Does anyone know if you can automatically link the name of the individual sheet tab name to a cell in the same sheet?

    In other words, if the sheet tab name is "Trains 09" I'd like to be able to have this title show up in a cell in the spreadsheet.
    bones252100's Avatar
    bones252100 Posts: 253, Reputation: 29
    Full Member
    		  
    #2

    Mar 1, 2009, 05:44 PM

    While you may not be able to link that info, you can format any cell or group of cells to display that info.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Mar 2, 2009, 02:22 AM
    Quote Originally Posted by yellowjacket83 View Post
    Does anyone know if you can automatically link the name of the individual sheet tab name to a cell in the same sheet?

    In other words, if the sheet tab name is "Trains 09" I'd like to be able to have this title show up in a cell in the spreadsheet.
    Yes it is possible, and it's very useful, especially if you're creating INDIRECT() formulas that utilize sheetnames in formulas. Very handy indeed.

    The formula to show the sheet tab name in a cell is:

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

    ... but that won't work until AFTER you've saved the sheet at least once.

    Quote Originally Posted by bones252100 View Post
    While you may not be able to link that info, you can format any cell or group of cells to display that info.
    This qualifies as "linking", so I would be interested to know what you were talking about in your hinted at alternate approach.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

Connect two different sheet in Excel 2007 [ 6 Answers ]

I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet. How I would relate these two sheets so that when I make any changes in the figure in the first sheet...

Excel Rounding off from REF sheet [ 12 Answers ]

My Excel is rounding off or up numbers when I multiply a cell in a sheet to a reference page in the workbook. (ie =(c38*'Bid Sheet'!k441) If I were to enter the number and not the reference cell it comes out correctly. This is simple math and not several decimals. 3*6 very often comes out as 19 as...

Working with Excel Links [ 2 Answers ]

I have a master spreadsheet (it is a price list) with multiple rows of information, organized by columns. I need to link the information in each row to different excel work sheets.

Tick Sheet for Excel [ 0 Answers ]

I am creating a "Table of Measurements" for a moving company in Excel, and they require that in the "# of pieces" cells that a number "1" or a similar character be placed in the cell rather than a "2" for two pieces or a "3" for three pieces, etc. So if there are 4 pieces, the cell would have...

View more questions Search