Display workbook file path, name and active sheet name

To display a workbook's file path, name and active sheet name in a single cell we can use the Excel CELL function

Example: Display workbook file path, name and active sheet name

Display workbook file path, name and active sheet name

METHOD 1. Display workbook file path, name and active sheet name

EXCEL

=CELL("filename")
This formula returns the workbook file path, name and active sheet name in which the formula is written in.

Explanation about the formula used to display workbook file path, name and active sheet name

EXPLANATION

EXPLANATION
To display a workbook's file path, name and active sheet name in a single cell we can use the Excel CELL function.

FORMULAS
=CELL("filename")