Get file location excel

See screenshot:. Kutools for Excel's Copy Full Path tool can easily copy current workbook's full path with only one click. The coped path is stored in clipboard, and you can paste it anywhere. Kutools for Excel : with more than handy Excel add-ins, free to try with no limitation in 30 days.

Get it Now. Insert Workbook Information. Open Containing Folder. Split Workbook. Note: The other languages of the website are Google-translated. Back to English. Type or paste the following formula as an array formula to display the current file name and active worksheet name:.

The formula returns the name of the worksheet as long as the worksheet has been saved at least once. If you use this formula on an unsaved worksheet, the formula cell will remain blank until you save the worksheet. When you save the worksheet, the error is replaced by the file name. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Need more help? Expand your skills. Get new features first. Was this information helpful?

Yes No. By default, when you open a workbook, the workbook name is display in the title bar. But sometimes, you want to display the full path in the tile bar or toolbar in your Excel file. Have ever tried to deal with this problem by yourself? Today, I can introduce you some quick tricks to show full file path in the title bar or toolbar in a workbook.

Show full file path in title bar in Excel. Show full file path in toolbar in Excel. In Excel, there is no direct way for you to display the full path in title bar, but you can apply the following simple VBA code, please do as this:.

Then press F5 key to run this code, and the full file path is displayed in the title bar at once. See screenshot:. Note: When you rename the workbook, the path will not automatically updated, you need to rerun this code to update the path of the Excel file.

If you want to show the full path in the toolbar of your workbook, you can finish it with following steps:. Then click OK to close this dialog, and the full file path has been displayed in the toolbar, see screenshot:. Note : This method cannot update automatically when the file is renamed, either. How to insert last modified date in Excel header or footer? Note: The other languages of the website are Google-translated.