Discussion Locked
Filename and Path in Hdr/Ftr of Excel 2K
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.