Home

 

Course Topics

 

Tips & Tricks

 

Why NSS

 

NSS Overview

 

Contact NSS

 

Training Rates

 

Media Room

 

Privacy Policy

 

 

 

 

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