Autocalculate

[Tom]

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?

 

[Gaijintendo]

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.

 

[Tom]

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

 

[John C]

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.

 

[MartinW]

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]

yes Martin I believe the alt+ shortcut was what I was looking for.Thanks for
the help and thanks to everyone who replied.