top of page

Where's that Spreadsheet!

Filename, Filename, my filename and sheet name! We work with hundreds of spreadsheets and frequently spend hours just trying

to find the filepath location of the last instance where we used the sheet. We like to customize my Header and although Excel offers Header, the format is not our style. Here are two tips that we found for inserting the filepath and sheet name as well as the Day of Week functions - @CELL("filename",A1) and =TIME(A1,"ddd") We found these on a great site called https://exceljet.net/formulas Never loose sight of your files again!


Comments


Featured Posts
Recent Posts
Search By Tags
No tags yet.
Follow Us
  • Facebook Classic
  • Twitter Classic
  • Google Classic
bottom of page