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
- 445023 reads
Really handy. Used to have
Really handy. Used to have the ability to display the entire path in the title bar, but MickeySoft, in its infinite wisdom, decided we didn't need that anymore. I think that's called progress.
File full path (document location)
Thanks for the long formula on how to display the file full path directory!
I spent hours searching for this!
Pauline
Excel 2010 - Display File Path
hi, I just checked, and it works in Excel 2010.
- when you look at the ribbon, there are labels like Font and Alignment... right click on one of those labels to get the option to add the Quick Access Toolbar
Excell 2010 - File Path
Thank you! With your information I was able to locate the command on the ribbom. It is under Header/Footer. Again thank you!!!
Thank-you, thank-you, a
Thank-you, thank-you, a hundred times. Microsoft have driven me crazy with all the things the 2010 suite won't do!
Dee-Jay
Excel 2010 - Display File Path
Thank you Jesus!! :) I have been searching for over an hour for something like this :) Thanks!!
Thank you!
I had been looking for this now for over 2 years. This tip made my day.
Command to Display File Path on Toolbar
Oh boy, you guys are life savers. I got a new PC & it wiped out my old set ups. I was going NUTS trying to find this. Never would have guessed that "Document Location" was the command I was looking for. THANK YOU!!
Document location tip
Yes, thanks a lot for the tip!!
question
When you are working in a file, and then save it to a new location, is there a way to get the document location in the ribbon to update? Appears you have to close out of the file and then re-open it.