General discussion
September 23, 2003 at 05:28 PM
wille.kelly

Filename and Path in Hdr/Ftr of Excel 2K

by wille.kelly . Updated 23 years ago

Is it possible to place the path and filename automatically into the header or footer of an Excel 2000 spreadsheet? I know that creating a custom header and footer allows for filename and sheet name but not the entire file path. I have found two functions that will work on the spreadsheet you cannot place them in the header or footer. The =INFO(“directory”)function returns only the path and the =CELL(“filename”)function will return path, filename and sheet name.

This discussion is locked

All Comments