View Results of Calculating Selected Cells in Excel Status Bar

By Laura Noble

 
The Status Bar in Excel displays the formula result of selected cells without you creating a formula.

 
In the sample above, the Sale amounts for Charlotte Web have been selected. The result of the sum of the selected cells (1400) is displayed in the Status Bar. It is not necessary to select the cells containing text (i.e., Web and Charlotte) as Excel ignores the cells with text, but often it is easier to identify numeric values.

Right-mouse clicking on the Status Bar will open a short-cut menu where a different function can be selected to calculate.

 

Printer Friendly Version

Published in Networking Today, February 2004.

 

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer