Can someone please help me to remember

  • Thread starter Thread starter tzap_1998
  • Start date Start date
T

tzap_1998

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 to expand...

Click the summation icon in the toolbar, the one that looks a bit ike
an M on its side.
 
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
 
Back
Top