how you get the sum by using the mouse

[Guest]

sorry in advance but not sure which forum to put this in.

I used to be able to highlight an area of spreadsheet with the mouse and in
the bottom right corner it would say "SUM= the value of all the entries in
the cells."

Since i came back my holidays someones messed about with it nad now it says
"COUNT=the number of cells with values within the chosen range"

Its pretty annoying now as i found the SUM function better for my job
because I sometimes need rough values and can just highlight the area or pick
certain values using the control key.

I've tried looking about in formatting etc but have no idea what to do.

thanks,

CC

 

[Shatin]

Right-click anywhere on the bar at the bottom, i.e. the bar where you see
the sum or count results. A menu will pop up. Select "Sum" from the menu.

 

[Guest]

Right click on the count and then see your options. I use sum frequently but
others a useful also
HTH

 

[Guest]

I'm new at this & having some problems accessing forums but have a related
question to the mouse. When I right click a cell in Excel 2007 a box opens up
with some choices. Is there any way of inserting the Sum function into this
box?

 

[Bernard Liengme]

Click on the Ribbon's Home tab
Look over to the right - the Edit group
The symbol in top left corner is Sigma ? (a bit like a 'funny' E)
Click it and you get =SUM(.....
best wishes

 

[Guest]

Thank you, I understand that. What I am really trying to do is highlight a
cell, then right click the mouse & want to be able to select the Sum function
out of the dropdown box that opens when you right click the mouse. The box
includes cut, copy, insert etc. I use that sum function a lot on a large
spread sheet and each time have to go up to the edit box at top right of
screen. It would be so much easier to select from out of the box that opens
at the mouse location on the screen, so am wondering if there is any way to
add that sum function to the box that opens at the right click of the mouse.

 

[Bernard Liengme]

How about the keyboard shortcut ALT+= (Hold ALT and press =)
best wishes

 

[Guest]

That works, thanks.

How about the keyboard shortcut ALT+= (Hold ALT and press =)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email