Excel - Display the name and path of a spreadsheet

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!

Published by netty5. Latest update on September 25, 2012 at 08:22 AM by deri58.
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 (https://ccm.net/).
Excel - Adding the current date in cell
Excel - Import CSV: bad alignment of dates