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 with the Document Location command
- One-click to insert the current Excel file location in a cell with Kutools for Excel
- Insert the current Excel file location in a cell with a formula
Insert the current Excel file location with 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 Ribbon. We can add this command to the Quick Access Toolbar with the following steps:
- Step 1: Click File >> Option in Excel 2010/2013, or Office button >> Excel Option in Excel 2007;
- Step 2: In the Excel Options dialog box, click the Quick Access Toolbar button. See screenshot.
- Step 3: In the drop-down list of the Choose command from section, select the All Command;
- Step 4: Find out 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.
One-click to insert the current Excel file location in a cell with 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.
For more detailed information about Copy Full Path, please go to Copy Full Path.
Insert the current Excel file location in a cell with 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)
Relative articles:
Auto Open Those Workbooks Next Time
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
