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

Leave a Reply