Get Sheet Name In Excel Using Formula

Sometime for navigation purpose across sheets in excel we  display the content along with the sheet name which has it, for better usability.

Let’s see how we could get the sheet name in excel using only formula.

We will see a simple formula in excel using Cell function that will give us the name of the excel sheet.

Enter the formula below in any cell in which you want to have the sheet name.

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




Capture

Please notice that I have used the cell reference as A1, actually you could provide reference to any cell which doesn’t have any error.

Capture

Q1 is the name of my sheet.

Hope this helped.

Share The Knowledge

Random Posts

  • Second Minimum Value In Excel

    A very common interview question that is asked in an excel interview is to find the second minimum value in a […]

    Share The Knowledge
  • Return Formula As String In Excel

    Let’s see how to return a formula as string or formula as text in excel. We often come across a […]

    Share The Knowledge
  • Generate Random Dates In Excel

    In this post we will see how we could generate random dates between two given dates in excel. Creating dates […]

    Share The Knowledge
  • Check If A Cell Has An Error In Excel

    No matter how much we hate errors they seem to be inevitable.Sometimes dynamically we are required to check the cells if […]

    Share The Knowledge

Leave a Reply