Excel - Display the name and path of a spreadsheet

Ask a question

The tip below will show you how to automatically display the storage path and the name of any spreadsheet
  • Enter in a cell (E.g cellA1) the following formula:
    • =cell("filename", A1) 
  • After each backup and/or moving of files on your computer (or another), this formula will indicate the full path, file name and name of your worksheet.
  • If you include this line in the lines to repeated in your print settings, you'll have no troubles finding the digital version of a print job, even many months after registration!

Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team