![]() |
Can someone please help me to remember
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. |
Can someone please help me to remember
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/ |
Can someone please help me to remember
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. |
All times are GMT +1. The time now is 01:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com