I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to capture the sum and be
able to copy the answer into a cell. I used to know how to do this but can
not remember now for the life of me. It doesn't wrk to ctrl+c and you can't
right click. Can anyone enlighten me? Thanks in advance.

Thu, 24 Jan 2008 03:59:01 -0800 from tzap_1998 <tzap1998
@discussions.microsoft.com:
I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to capture the sum and be
able to copy the answer into a cell. I used to know how to do this but can
not remember now for the life of me. It doesn't wrk to ctrl+c and you can't
right click. Can anyone enlighten me? Thanks in advance.

Click the summation icon in the toolbar, the one that looks a bit ike
an M on its side.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Hi,

Maybe you are thinking of this one,
With a column of numbers highlighted,
Hit Alt+=
It will put the sum of those numbers into the next cell
It also works with a row of numbers

HTH
Martin


"tzap_1998" wrote in message
...
I have several numbers highlighted in Excel. When I look to the lower right
hand section of the Excel Window, I can see the sum of those numbers. If I
right click the sum, I can change to the maximum, the minimum, the average
and so forth. There are times it would be useful to capture the sum and be
able to copy the answer into a cell. I used to know how to do this but can
not remember now for the life of me. It doesn't wrk to ctrl+c and you
can't
right click. Can anyone enlighten me? Thanks in advance.