Kioskea
Recherche
Ask a question »

Excel - Display the name and path of a spreadsheet

March 2015


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!

For unlimited offline reading, you can download this article for free in PDF format:
Excel-display-the-name-and-path-of-a-spreadsheet.pdf

See also

In the same category

Original article published by megajojo. Translated by netty5. - Latest update by deri58
This document entitled « Excel - Display the name and path of a spreadsheet » from Kioskea (en.kioskea.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.