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:
=MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,256)
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.
If you only need the information on a printout and don’t want it displayed in a cell, you can edit the sheet’s header/footer. Click View | Header and Footer | then Custom Header or Custom Footer, depending on where you want the name to appear. Determine where you want the name to appear (Left, Center, or Right) and click the worksheet button (third from the right) that looks like a worksheet with three tabs below it.