Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Show Sheet Tab Name in Cell

  1. #1
    Join Date
    21st January 2005
    Posts
    12

    Show Sheet Tab Name in Cell

    Hi,

    does anybody know how to insert the title of the sheet tab into a cell on that sheet tab.

    regards,

    Paul.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,507

    Re: Sheet tab title in cell

    You can get the full path, file name , sheet etc by using

    =CELL("filename")

    An array formula can return the sheet name only

    =RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))

    To enter a formula as an array formula, press CTRL+SHIFT+ENTER.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  3. #3
    Join Date
    2nd November 2005
    Location
    Wessex
    Posts
    1,267

    Re: Sheet tab title in cell

    That's not just a sheet name, it iw workbook and sheet name.

    The sheet name can be obtained more easily with

    =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
    HTH

    Bob

  4. #4
    Join Date
    21st January 2005
    Posts
    12

    Re: Sheet tab title in cell

    Cheers,

    thanks for that.

    regards,

    Paul.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Sheet tab title in cell

    See also Return an Excel Worksheet Name to a Cell

    BTW, a search would have resulted in MANY results as the question has been asked many times over.

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Possible Answers

  1. Show UserForm On No Cell Value In Hidden Sheet
    By morgado in forum EXCEL HELP
    Replies: 3
    Last Post: August 6th, 2008, 13:05
  2. Show Pop-Up To Choose Sheet
    By tobeychris in forum EXCEL HELP
    Replies: 10
    Last Post: June 11th, 2008, 18:02
  3. Show Cell At Random From Another Sheet
    By chasbogo in forum EXCEL HELP
    Replies: 4
    Last Post: February 2nd, 2008, 04:03
  4. Replies: 2
    Last Post: June 29th, 2006, 00:55
  5. Show the last sheet of a workbook
    By Mickey690 in forum EXCEL HELP
    Replies: 2
    Last Post: April 12th, 2005, 01:56

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno