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
Follow Us
  • Facebook Classic
  • Twitter Classic
  • Google Classic
We Get Deals Done!
Business Growth Advisory.
Good Planning, Preparation, and Positioning. 
linkedin white.png
Be 'in the know' about your market:

Thanks! Message sent.

STEP Strategy Advisors   |   11620 Wilshire Boulevard   |   Los Angeles   |   California   |   90025
Investment Banking Services and Securities Products are offered through BA Securities, LLC.   Member FINRA SIPC.   
STEP Strategy Advisors and BA Securities, LLC are separate, unaffiliated entities.

© 2025 by STEP Strategy Advisors 

bottom of page