Often times it’s useful to be able to display your worksheet’s name in a cell in the worksheet. This could be tedious if you have a file with a lot of sheets, whose names could change frequently. Luckily there are a couple ways around this problem.

If you want to display this information in a cell in your file, enter the following formula in the cell where you want the name to appear:

=RIGHT(CELL(“filename”,A1),LEN(CELL(“filename”,A1))-SEARCH(“]”,CELL(“filename”,A1)))

Anytime you change your sheet’s name, the formula will automatically update, so you never have to edit the name in the worksheet as well.