Placing the Worksheet Name in a Cell
While you can always place workbook names in headers or footers, there might be a time when you want to place the worksheet name directly on the worksheet. You can use the CELL formula to do this. First, save and name the workbook. The formula will not work unless the workbook is saved and named. If you want to name the actual worksheet, go ahead and do that too. Then, in a blank cell, type:
=CELL(“Filename”)
and press Enter. Excel places the worksheet name and path in the cell. If the Save As command is used to change the name or location of the workbook, you must click in the formula bar, at the end of the =CELL(“Filename”) formula to update the formula or press F9 to recalculate the worksheet.
