How do I add cells by highlighting them?



Normally, I can add numbers in different cells by highlighting those cells.
The sum will then appear at the bottom of my screen.

For some reason, my excel program has stopped doing this. Now, when I
highlight multiple cells with my cursor, excel only adds up the number of
cells. For instance, if I highlight 5 cells, it will say "count = 5."

I'd really like to be able to sum totals by highlighting cells again. How do
I get this function back?


right click the status bar (the bar where the sum appears)
from the popup, click sum.

you may want to make not of all of the other options available.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question