Just like the header of a company’s letterhead or titles and chapters within a book, there may be instances where you may want a cell within the worksheet to reference the name of the tab.

This can be useful when reconciling items and future proofing the cell value by making it automatically update with any changes to the tab name.

Syntax

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

You can enter the formula above in any empty cell on your active worksheet and the value returned will be the name of the tab as show below.