Excel - Display the name and path of a spreadsheet

March 2017




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


Published by netty5.
This document, titled "Excel - Display the name and path of a spreadsheet," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).