Return the Worksheet Name to a Cell in Microsoft Excel

Tip: In the formulas below, "filename" is exactly what you type, it's not something that means you're supposed to type your file name.

  • Type the following formula into the cell where you want the worksheet name to appear:


  • Use the following formula to get the entire path, workbook name, and sheet name