NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

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.
 

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

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