71. Excel Tips - Display Excel File Path

Nick's picture


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:

display-excel-file-path

 

Steps to display the file path of the current open file (Excel 2007):

  1. Right click on the ribbon
  2. Choose "Customise quick access toolbar"
  3. Select "All commands"
  4. Then choose "Document Location"
  5. Click "Add".. and it will appear on the right

display-excel-file-path

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:

AttachmentSize
display-excel-file-path.xls27.5 KB
FreddieWeeks's picture

On PRINTOUT, in Footer, also Add FULL File Path, Excel 2010

I find it very useful to have the Filepath Details on a Printout, within the Footer:
On Excel Menu Toolbar, goto Page Layout, Print Titles, Header/Footer, Custom Footer:
Now you can add how you wish your details to appear from a list of several pre-offered very useful selections.
Add any other wording you require amongst these details.
Mine reads:
'Confidential Discretion Required',
Shows Full Path and Filename,
Date and Time of Printout allowing easy sorting/scrapping/shredding of OLD printouts, I add the words; 'Dated and Timed'
Page Numbers if required,
And since you are already in Page Setup, adjust margins on the Margin Tab,
Another useful item; on Sheet Tab, add any Rows you wish to include on the Top of future Printouts, should you need any Columns at the left they can be printed at the same time, on every printout page, in the future, of that Worksheet
Hope I am not overstepping the original intention of Nicks wonderful pointers on Screen Filepaths,
Good wishes anyway, Freddie

Very useful

Very easy to find it .:) good one....

not much useful

not really in long paths you can't see the full path...

Nick's picture

the only thing you can do for

the only thing you can do for really long paths is to copy and paste to notepad or something... (and there is nothing Excel can do about that anyway)

Thanks a lot..... It

Thanks a lot..... It worked...... :)

display of the path of a file

your method works great for Excel and is very simple. Thanks a lot.
However, I have not found a similar method for MSWord.
Even though this is not your specialty, you probably know about it.
Please let me know.
Thanks again.
Benjamin.

benjaminvis@yahoo.com

Thanks!

Just a quick thank you! This has been super useful :)

display-excel-file-path.xls

Many thanks for sharing. It is really helpful to me.

file path

Thanks Nick. Very Helpful.

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???

Nick's picture

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

This feature is gone in Excel 2010

I am using Excel 2010 and now Document Location is missing from the Command list. Is there any way to get it back and/or have the renamed it again?

Web>Address begat Document Location begat ????

document path

After several attempts & looking at various help messages, I noticed that after getting to the customize ribbon and the list of commands you can add, there's another box above it for "all commands". There I found "Document location".

Now, if I could only find a way to have the location automatically be inserted into the workbooks, I'd be happier. Also can't copy into the footer, where I'd prefer it.
Thanks if anyone can guide me on this.

Good site here!!
Sidney

Thanks! That worked for me!

Thanks! That worked for me!

Excel 2010

In the list of All Commands, the file name/path is called "Address".

Thanks

Thanks a bunch!!!

Thanks a lot, amazingly

Thanks a lot, amazingly simple yet so useful!

Nick's picture

full file path

 

don't have 2010 yet, but I have a formula that might help you:

 

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

returns:

Book6.xls

 

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

returns:

C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls

 

having the file path is really useful

  • You can attach files to emails easily
  • if you want to open the file in a new Excel session, just copy the file name and go:

Start => Run => type "Excel" paste your path, and wrap it in '

so will look like this:

excel 'C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls'

press Enter

 

Nick

Sheet names

This:
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

returns:
C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls

is EXACTLY what I've spent the last 40 minutes looking for (apparently, my Google-Fu is weak today).

How do you amend that code so that it includes the sheet name, also? I'd like for the code to return:
C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls | Sheet1
or
C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls[Sheet1]

Thanks so much for your help and expertise.
~L~

Nick's picture

and if you just want the path

and if you just want the path without the file name, use this:

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

so for this:
'C:\Documents and Settings\Any Authorised User\My Documents\Book6.xls'

it returns this:
C:\Documents and Settings\Any Authorised User\My Documents\

thank you!!!

that was a beautiful, brilliant formula. So helpful and easy. Thank you!!!
---busy worker bee

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

Nick's picture

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.

Nick's picture

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.

Nick's picture

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

  • you can get the file path using a formula, so no copying and pasting needed.