Excel trick: auto fill formula for all rows with data
Just learned a nice little Excel trick watching my new favorite Channel 9 show Defrag tools (and had a good laugh reading Chad Beeders comment to a hater. Check out his t-shirt, and go check the comments on the Channel 9 page, link below.)
Take a look at [09:07] in episode 157:
(this link takes you exactly there: https://channel9.msdn.com/Shows/Defrag-Tools/Defrag-Tools-157-Energy-Estimation-Engine-E3?ocid=EntriesInArea#time=09m07s
Apparently, if you make a cell formula, and double-click on the lower right corner of the cell, the formula auto fills for all rows with data beneath that cell.
That is a very nice Excel feature, which I didn’t know until this morning.