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
- 448418 reads
Thank You
This is great for me to share links to dum-dums! I used to do right click and then web. Many Thanks!
wow
only site having the information iam searching for a long time.
Dont know why MS did this and troubleing all of us., this was great and really really useful thanks a lot !
This site is amazing
Guys keeping adding to this...
Superb site
Aravinda
Singapore
FILE PATH INCL.CELL NUMBER
Does anyone know how to create filepath including cell number?
i want another user to check Cell number that i added in hyperlink.Is it possible???
confused... can u give
confused... can u give example of what you mean ?
Very usefull , exactly what i
Very usefull , exactly what i needed
Thank you. Your generosity
Thank you. Your generosity in sharing your knowledge is greatly appreciated.
Absolute Path
Hello Folks,
maybe you can help me a bit here - I also suffered from finding the Web tool bar from 2003 in the 2011 Office. Now I have Document location and I have the link - that works well.
What I still have not found out after hours of search and driving our IT department nuts is the way to display the absolute path.
We are using windows shares and I like to send the location of new files via absolute path, not relative, as you sometime have different mapped drive letters.
Cheers!
Andy
example:
I do not want to see
N:\Templates(Andreas)\newtemplate.potx
but
\\servername\directory\Templates(Andreas)\newtemplate.potx
Cheers!
Andy
file path
odd.. I have never seen it map to the drive mapped path.. it's always the full unc path for me