Open your spreadsheet in Microsoft Excel 2007. Click the first data point in the column to select it. Hold the "Shift" key and click the last data point in the list.

TL;DR Key Takeaways : Excel 365 offers a feature called calculated columns, which allows for dynamic calculations that automatically update with changes in data.