Jump to content



Sign up for a free account!

Signing up for an account is fast and free. As a member you can join in the conversation, enter contests to win things like this Logitech Harmony Ultimate Remote and you won't get the popup ads that guests get. Click here to create your free account.

Photo
- - - - -

Excel Help: How to reference tab name in cell


  • You cannot start a new topic
  • Please log in to reply
12 replies to this topic

#1 of 13 Mark Giles

Mark Giles

    Second Unit

  • 272 posts
  • Join Date: Aug 30 2002

Posted June 26 2006 - 05:23 AM

In Microsoft Excel: Can someone tell me the formula on displaying the name of the worksheet (tab name) in a cell on the sheet? I'm not talking about the header/footer code, but in a cell.

I know theres a way to do it, I just forget what the formula is.

Thanks in advance!! Posted Image

#2 of 13 Mark Giles

Mark Giles

    Second Unit

  • 272 posts
  • Join Date: Aug 30 2002

Posted June 26 2006 - 05:45 AM

Ok, nevermind. i found it...

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

#3 of 13 me90201

me90201

    Auditioning

  • 1 posts
  • Join Date: Jul 14 2011

Posted July 14 2011 - 02:06 AM

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

#4 of 13 mrtonothorns

mrtonothorns

    Auditioning

  • 2 posts
  • Join Date: Jul 18 2011

Posted July 18 2011 - 06:42 AM

Ok, nevermind. i found it...

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

SWEET! Now can someone tell me how to find the name of the cell that is to the left of the tab I am putting the formula in?

#5 of 13 mrtonothorns

mrtonothorns

    Auditioning

  • 2 posts
  • Join Date: Jul 18 2011

Posted July 18 2011 - 06:42 AM

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

SWEET! Now can someone tell me how to find the name of the cell that is to the left of the tab I am putting the formula in?

#6 of 13 Still a novice

Still a novice

    Auditioning

  • 1 posts
  • Join Date: Aug 21 2012

Posted August 21 2012 - 05:43 AM

Did you ever get an answer to the question regarding the name of the worksheet to the left? If so, I would appreciate you sharing it with me. Thank you

#7 of 13 Kirk Lammert

Kirk Lammert

    Auditioning

  • 1 posts
  • Join Date: Nov 13 2012

Posted November 13 2012 - 04:04 AM

You can use the same formula with a minor alteration to the CELL function. The original formula: =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) assumes that you want the name of the tab you're currently on. However, there is a second argument to the CELL function for reference. Using this argument you can get the tab name of any tab within your worksheet. It works like so: =RIGHT(CELL("filename",'OtherTab'!A1),LEN(CELL("filename",'OtherTab'!A1))-FIND("]",CELL("filename",'OtherTab'!A1))) where "OtherTab" is the tab you want to get the name of. I used cell A1 of that sheet, but any cell will do. Hope this helps!

#8 of 13 Y Jin

Y Jin

    Auditioning

  • 1 posts
  • Join Date: Dec 18 2012

Posted December 18 2012 - 02:27 AM

Kirk, that's very helpful! I have more than 1 tabs in my spreadsheet book. If I want a specific cell in each tab read its own tab name what should I do? I used your first formula, all tabs read one tab name. Any suggestion? Thanks!

#9 of 13 Mr SteveW

Mr SteveW

    Auditioning

  • 1 posts
  • Join Date: Dec 26 2012

Posted December 26 2012 - 04:04 PM

Hi Kirk or Mark: I have a strange result using your formulas for returning value of the same sheet you are on and wondering if you're experiencing the same. If I rename any other sheet name in the entire workbook (or any other open workbook for that matter), and the formula (even though referencing the sheet I am on) changes value to show me the name of the most recently modified sheet name. Doesn't matter which book I'm in. If I recalculate the formula (click in cell and press Enter) it goes back to showing me the correct "current sheet name". If I close the book and reopen it, the book opens with the correct "current sheet name". So it seems like it experiences only a temporary glitch, but can cause problems on formulas within the page while I'm working in my workbook... any ideas on how to keep it from changing temporarily? Thanks.

#10 of 13 ryates

ryates

    Auditioning

  • 1 posts
  • Join Date: Jan 07 2013

Posted January 07 2013 - 06:06 AM

Hi All: Yes, i find that in multiple sheets the cell reference returns the name of the first or current sheet tab. What would be helpful is if i cound have a relative reference to the sheet tab name unique to each sheet.

#11 of 13 MikeR128

MikeR128

    Auditioning

  • 1 posts
  • Join Date: Jan 22 2013

Posted January 22 2013 - 04:33 AM

You just need to set the reference to an absolute cell on the sheet. Thus cell("filename","$A$1") will alway only refer to the current sheet where it appears and =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1),1)) will always give the correct Tab reference.

#12 of 13 snowwhiteeg

snowwhiteeg

    Auditioning

  • 1 posts
  • Join Date: Mar 23 2013
  • Real Name:snowwhiteeg

Posted March 24 2013 - 04:40 AM

RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))



#13 of 13 Sam Posten

Sam Posten

    Moderator

  • 15,614 posts
  • Join Date: Oct 30 1997
  • Real Name:Sam Posten
  • LocationAberdeen, MD & Navesink, NJ

Posted April 12 2013 - 08:17 AM

This thread delivers.


"Sam, you are the biggest nutter we have here."

Blog: Navesink.net - My Flickr Stream - Dolby Atmos Discussion Thread - Updates at Twitter - Join the HTF Flickr Pool





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users