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

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.

"CC" wrote in message
...
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

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

"CC" wrote:

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

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?

"CC" wrote:

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

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"normike" wrote in message
...
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?

"CC" wrote:

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

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" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"normike" wrote in message
...
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?

"CC" wrote:

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

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

"normike" wrote in message
...
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" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"normike" wrote in message
...
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?

"CC" wrote:

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

That works, thanks.

"Bernard Liengme" wrote:

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

"normike" wrote in message
...
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" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"normike" wrote in message
...
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?

"CC" wrote:

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