Finally, enter Qtr1 Total heading at top of column in cell E2, and youre do! If you have trouble selecting Quick Analysis tool to open its palette for any reason, simply select cells to be calculated and then press Ctrl + Q or right-click cell selection and click Quick Analysis item on its context menu. Add column of quarterly Running Totals down rows in cell range E3: E11 by selecting Quick Analysis tool again and then selecting Totals followed by SUM option that is to the immediate right of Running option. To add Running Totals to the sample worksheet Table shown in Figure 2-20, you simply select the Table of data, A2 through D11, and click Quick Analysis tool followed by Totals and Running Total buttons. To actually add SUM formulas with Totals to new row or column, you simply click the Running Total or SUM button.
You can then use your mouse or Touch Pointer to have Live Preview show you Totals in the new row at bottom by highlighting Running Total or in the new column on the right by highlighting SUM. To add Totals to your select Table data, simply click the Totals button. When you do, palette of options appears right beneath the tool. To use the Quick Analysis tool, all you have to do is select worksheet Tables cells and then click Quick Analysis tool that automatically appears in the lower-right corner of the last selected cell. And it turns out Quick Analysis is also a whiz at adding Running Totals and sums to rows and columns of your new worksheet tables. The Quick Analysis tool offers a bevy of features for doing anything from adding Conditional Formatting, Charts, pivot Tables, and Sparklines to your worksheet Tables.
For those of you who do have time or patience to add Totals to your Excel 2016 worksheet Tables with AutoSum and AutoFill, Excel 2016 Totals feature on the Quick Analysis tool is just thing.