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
- Login or register to post comments
- 445148 reads
It's a bug
Yeah.. that annoys me too.. it's a bug in Excel. Note that if you do the same in Word or powerpoint, it does update.
The only way I have found to make it update is to create a new workbook (CTRL + N), and then press CTRL + TAB to select the old one.
it will then update.
I'll have a word with my insiders at MS..
Display Excel File Path
Thank you Thank You Thank You
Thanks a lot very useful -
Thanks a lot very useful - Rasesh
Excel File Path
This was very helpful. thanks a ton!
- Kishore.
Display File Path
Congratulations ! I couldn't find the damned thing. I was lost after not finding the 2003 option of Web Address.
Damn Microsoft !
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.
How to display excel file path in Excel for Mac 2008
I tried to display the excel file path in my excel for MAC 2008. I coudnt do this. Although i found "Customized toolbars and menus" and got "All Commands" category but i couldnt find the "Document location" command.
Please suggest
Mamoon
Excel 2007 File Path
LOVE it. Thank you so much!
Excel 2007 file path
Brilliant!!!!!
Kudos for the amazing discovery....though i feel microsoft
did mess up abit on their 2007 products.
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