Excel - Display the name and path of a spreadsheet

October 2016

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!

Related :

This document entitled « Excel - Display the name and path of a spreadsheet » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.