Welcome toExcel2007.Tips.Net
Helpful Links
Cleaning Tips
Gardening Tips
Home Tips
Organizing Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Status Bar Doesn't Show Sum of Selected Range
Summary: When you select a range of cells, Excel normally displays the sum of those selected cells on the status bar. If the sum no longer appears, here's how you can get it back.Steve notes that he used to be able to highlight a row or column of numbers in Excel and the sum of that row or column would appear on the status bar. All of a sudden the sum has stopped appearing, and Steve wonders how to get it back.
Excel can use the status bar to show several different statistics about your selection, not just the sum. Right-click the status bar and you should see a Context menu appear that offers quite a few options. A portion of those options deal with choices relative to the selection: Average, Count, etc. You can select any of these options and have them displayed on the status bar. You should make sure that the Sum option is selected, then you will see the sum you desire.
Related Tips:
Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!