Download the featured file here: https://www.bluepecantraining.com/apply-formula-to-multiple-cells-in-excel-use-the-same-formula-in-entire-column-row-or-table/

In this video, I demonstrate how to apply a formula to multiple cells in an Excel worksheet. For example, you may want to apply the formula to an entire column, row or table.

I look at four methods:
1) Using the fill handle
2) Using shortcut keys CTRL ENTER, CTRL D and CTRL R
3) Using Excel Tables
4) Using dynamic array formulas (only available in Excel 365)
------------------------