71. Excel Tips - Display Excel File Path
This is an extremely useful tip if you did not already know it:
- There's a way in Excel to display the file path of the current open file.
- You can add it to your toolbar, and then copy it from there whenever you need it.
Here's a screen shot of our Excel:
Steps to display the file path of the current open file (Excel 2007):
- Right click on the ribbon
- Choose "Customise quick access toolbar"
- Select "All commands"
- Then choose "Document Location"
- Click "Add".. and it will appear on the right
In Excel 2003, right click on the toolbar, and choose to display "web"
Note: If you have not saved the file, only the workbook name will be displayed.
Download sheet to practise how to Display Excel File Path in Excel
Training Video on how to Display Excel File Path in Excel:
| Attachment | Size |
|---|---|
| display-excel-file-path.xls | 27.5 KB |
»
- Nick's blog
- Add new comment
- 1145 reads
Excel 2007 file path
Thanks for the tip it was very useful.
I succefully added the file path on the toolbar however its not very wide and it shows only the half of the path so to see all I had to select->scroll right/left. At the end I just copied and pasted it to a cell in order to see the full path
It would be nicer if the field was wide enough to showe the full path.
file path
I don't know of a way to make it bigger..
You might be interested in this instead: excelexperts.com/Excel-Tips-file-path-formula