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)
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.
Q1 is the name of my sheet.
Hope this helped.