Where's that Spreadsheet!

January 11, 2016

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!

 

 

Please reload

Featured Posts

Throw Out Your Organization Chart!

July 24, 2019

1/5
Please reload

Recent Posts

March 1, 2019

November 23, 2018

October 14, 2018

September 14, 2018

August 14, 2018

June 14, 2018

Please reload

Search By Tags
Please reload

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

© 2019 by STEP Strategy Advisors