Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Someone Please remind me How to do this
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Someone Please remind me How to do this
On 24 Jan, 11:58, tzap_1998
wrote: 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 You can select cells, then click Autosum ( Ó ) which sums them. Or you can type =SUM(A1:A3) into any cell to sum cells A1, A2, and A3. Joe. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Someone Please remind me How to do this
tzap
I think what you are looking for is the "Status Bar". Goto toolsoptionsveiw tabShowStatus bar. Now what you are looking for is in the lower right corner with all the commands you described. Mike Rogers "tzap_1998" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a trigger to remind me of tasks in excel | Setting up and Configuration of Excel | |||
formula to remind me of an appointment 3 months in the future | Excel Worksheet Functions | |||
Use of conditional formatting to remind of forthcoming birthdays | Excel Worksheet Functions | |||
can a cell remind you of an upcoming bill date payment | Excel Discussion (Misc queries) | |||
How do I input a warning message to remind the user to enter into. | Excel Discussion (Misc queries) |