How to insert the current Excel file location in a cell of Excel?

Inserting the current file location into an Excel cell manually can be cumbersome, as it typically involves searching for and typing out the file path. To streamline this process, this article will introduce three efficient methods to quickly display or insert the current Excel workbook's location or file path directly into a cell, simplifying your workflow.

• Insert the current Excel file location by the Document Location command
• Insert the current Excel file location in a cell by Kutools for Excel
• Insert the current Excel file location in a cell by a formula

Insert the current Excel file location by the Document Location command

In Excel, we can display the current Excel file's full path using the Document Location command. However, this command is not in the Ribbon. We can add this command to the Quick Access Toolbar with the following steps:

• Step 1: Click "File" > "Option" in Excel.
• Step 2: In the "Excel Options" dialog box, click the "Quick Access Toolbar" button.
• Step 3: In the drop-down list of the "Choose command from" section, select "All Commands".
• Step 4: Find out the "Document Location" item and select it.
• Step 5: Click the "Add" button.
• Step 6: Click the OK button.

Then the Document Location command is added to the Quick Access Toolbar. See screenshot.

It displays the current workbook's saving path in the Document Location box. We can copy the path and paste it into any cell.

Insert the current Excel file location in a cell by Kutools for Excel

Kutools for Excel's "Copy Full Path" tool can easily copy the current workbook's full path with only one click. The copied path is stored in the clipboard, and you can paste it anywhere.

Step 1: Click the "Kutools Plus" > "Workbook" > "Copy Full Path". See screenshot.

Step 2: Paste the copied path in any cell.

Insert the current Excel file location in a cell by a formula

If you are familiar with Excel formulas, you can get the current Excel file's location in a cell directly by entering the formula below.

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

Related articles:

Insert Workbook Information

Auto Open Those Workbooks Next Time

Split Workbook