Worksheet names in Excel Cells If you are working in Excel, and you want to show the worksheet name in a Cell on that worksheet, you can use the CELL function to do so.
By default the CELL function will return the current document name, if used with the filename info_type:
=CELL("filename")
This provides a full path to the spreadsheet, with the worksheet of the current Cell at the end, e.