Can u add cells in Excel without pressing "shift +" one by one?

[~vanna~]

I'm trying add a bunch of cells together, but it seems I have to press "shift
+" everytime inbetween selecting cells. Is there an easier way to do this?
When I DO try to select a bunch of cells (from top to bottom) in a column -
it puts colons between the cell numbers ":" - does this mean they are being
added together, divided, or multiplied?

 

[Peo Sjoblom]

If you want to add A1 to A10 just use

=SUM(A1:A10)

if you want to add A1, A4, A8

=SUM(A1,A4,A8)


the latter done by mouse would include holding down ctrl and clicking on
each cell.
But that is only if the cell mare not adjacent to each other, if they are
just type =SUM( and then
select the adjacent cells with the mouse


--


Regards,


Peo Sjoblom