Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
Is there a way to get the answers from the autocalculate area into the actual
spreadsheet. In word you just copy it and paste. In Excel the answer appears in the autocalculate area but if you want to use the resulting answer in the spreadsheet , is there a way to copy the rsults to the spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
If I understand you correctly you seem to be asking about functions.
When you select cells, Autocalculate might give you the SUM for example. Say you select callse A1 through A5, you could type this in a cell as: =SUM(A1:A5) and this will display the sum of that range of cells. In the same way you can use MIN, MAX,COUNT and AVERAGE. These will update if you change the contents of the cells used for the calculation. If you want to move these valuse, or freeze them (stop it being a function) you can copy the cells, and 'Paste Special' just the values. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
I know how to use the various functions. I used to know a way to copy teh
actual answer from the autocalculate area onto the clipboard so it could be pasted or used. That is what I am looking for. Thanks "Tom" wrote: Is there a way to get the answers from the autocalculate area into the actual spreadsheet. In word you just copy it and paste. In Excel the answer appears in the autocalculate area but if you want to use the resulting answer in the spreadsheet , is there a way to copy the rsults to the spreadsheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
Are you referring to the MS calculator? If so, you can still copy and paste.
Or, are you referring to the cell that has the answer (i.e.: say cell A5 had =SUM(A1:A4). You can copy from this cell as well. If you want just the value, I recommend when you paste to use the paste special function-value only. -- John C "Tom" wrote: I know how to use the various functions. I used to know a way to copy teh actual answer from the autocalculate area onto the clipboard so it could be pasted or used. That is what I am looking for. Thanks "Tom" wrote: Is there a way to get the answers from the autocalculate area into the actual spreadsheet. In word you just copy it and paste. In Excel the answer appears in the autocalculate area but if you want to use the resulting answer in the spreadsheet , is there a way to copy the rsults to the spreadsheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
Hi Tom,
Are you maybe thinking of the Alt+= shortcut? You select a row or column of data and tap Alt+=(equal sign) and it will insert the autosum value in the next cell. HTH Martin "Tom" wrote in message ... I know how to use the various functions. I used to know a way to copy teh actual answer from the autocalculate area onto the clipboard so it could be pasted or used. That is what I am looking for. Thanks "Tom" wrote: Is there a way to get the answers from the autocalculate area into the actual spreadsheet. In word you just copy it and paste. In Excel the answer appears in the autocalculate area but if you want to use the resulting answer in the spreadsheet , is there a way to copy the rsults to the spreadsheet? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocalculate
yes Martin I believe the alt+ shortcut was what I was looking for.Thanks for the help and thanks to everyone who replied. "MartinW" wrote: Hi Tom, Are you maybe thinking of the Alt+= shortcut? You select a row or column of data and tap Alt+=(equal sign) and it will insert the autosum value in the next cell. HTH Martin "Tom" wrote in message ... I know how to use the various functions. I used to know a way to copy teh actual answer from the autocalculate area onto the clipboard so it could be pasted or used. That is what I am looking for. Thanks "Tom" wrote: Is there a way to get the answers from the autocalculate area into the actual spreadsheet. In word you just copy it and paste. In Excel the answer appears in the autocalculate area but if you want to use the resulting answer in the spreadsheet , is there a way to copy the rsults to the spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocalculate field | Excel Discussion (Misc queries) | |||
Autocalculate does not work | Excel Worksheet Functions | |||
Autocalculate | Excel Worksheet Functions | |||
AutoCalculate doesn't see my data | Excel Discussion (Misc queries) | |||
Shortcut for autocalculate | Excel Discussion (Misc queries) |