« I need a geometry expert. If I have an apple pie, how do I slice it into 5 equal pieces?
Algebra 2 - Conic Sections - Ellipses »

How do you make the sheet name appear automatically in a cell in an excel worksheet?

There is a way to make the name of the sheet appear in the header. What I would like to see is the name of the sheet automatically appear somewhere within the worksheet itself. I plan to use this as a template such that there will be worksheets with different names in the future. How can one make the sheet name appear automatically in a particular cell in an excel worksheet?

copy&paste this formula

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

you can do much more (filename, filepath)…see source.

This entry was posted on Thursday, August 20th, 2009 at 12:18 am and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How do you make the sheet name appear automatically in a cell in an excel worksheet?”

  1. Sarah M Says:
    August 20th, 2009 at 5:26 am

    There might be a more straight-forward way, but this works:

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

    A1 can be any cell in the sheet.
    References :

  2. expletive_xom Says:
    August 20th, 2009 at 5:39 am

    copy&paste this formula

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

    you can do much more (filename, filepath)…see source.
    References :
    http://www.exceltip.com/st/Cell_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html

Leave a Reply