In this section, I introduce a handy tool – Insert Workbook Information utility of Kutools for Excel for you. In the above formulas, A1 is a variable, you can change it to any other cell reference.Įasily get workbook information (sheet name, file name/path, etc.) with an amazing tool Except the above formula, you can also use this formula: Enter or copy the below formula into it and press the Enter key to get the filename. Select a blank cell to output the workbook name.Ģ. The below formulas can help you to get the filename excluding the extension quickly, please do with following steps:ġ. Return filename without extension to cell with formulas Download Kutools for Excel now! ( 30-day free trail) The Insert Workbook Information utility of Kutools for Excelcan help you easily insert workbook information in a cell, header or footer of a workbook as the below demo shown. Easily get workbook information (sheet name, file name, file path, etc.) in Excel:
