Get The Workbook And Sheet Name With A Formula

less than 1 minute read

These formulas require that the workbook is saved

Get the file name of this workbook:

Result: C:[MyWorkbook.xlsx]Sheet1

Get the file name of this workbook without the file extension:


Result: MyWorkbook

Get the active sheet name:


Result: Sheet1

Reference another sheet name:


Result: ‘Sheet1!

Tags: lookup-reference, text-strings

Categories: formulas

Updated: September 27, 2018

Twitter Facebook LinkedIn

Leave a Comment