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!


Featured Posts
Recent Posts
Search By Tags
No tags yet.
Follow Us
  • Facebook Classic
  • Twitter Classic
  • Google Classic
We Get Deals Done!
We Support Business Growth.
Good Planning, Preparation, and Positioning. 
Be 'in the know' about your market:
STEP Strategy Advisors

11620 Wilshire Boulevard   |   Los Angeles   |   California   |   90025

© 2020 by STEP Strategy Advisors