View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default 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/