Another handy feature of Excel is the AutoCalculate,
this enable us to at a glance get a calculations without having to input or construct formula in the Excel sheets.
There might be times when you wish to find out the sum, average, count, Minimum of a range of numbers quickly without having to add a formula to the Worksheet. For these instances, we can quickly make use of this feature of Excel.
To do this, just select the range of cells containing the data's you want to calculate, then look right at the Status bar and if it is not showing the sum of the selected cells or the required calculations, right click on the status bar and select the preferred auto calculation you want to enable on that screen, select again to disable any one you don't want, also no harm in activating everything down as you may require.
There might be times when you wish to find out the sum, average, count, Minimum of a range of numbers quickly without having to add a formula to the Worksheet. For these instances, we can quickly make use of this feature of Excel.
To do this, just select the range of cells containing the data's you want to calculate, then look right at the Status bar and if it is not showing the sum of the selected cells or the required calculations, right click on the status bar and select the preferred auto calculation you want to enable on that screen, select again to disable any one you don't want, also no harm in activating everything down as you may require.
Tip: you can select multiple cells that do not fall under same column or rows by hold down the Ctrl key while selecting the cells or ranges.
Post a Comment