Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "~vanna~" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing grouping in Excel I get "Cannot shift objects off sheet"? | Excel Discussion (Misc queries) | |||
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" | Excel Discussion (Misc queries) | |||
Excel error "Cannot shift objects off sheet", can I fix? | Excel Discussion (Misc queries) | |||
colour fonts revert to black when pressing "Enter" | Excel Discussion (Misc queries) | |||
How do I turn on "pressing enter goes to the next cell" option? | Excel Discussion (Misc queries) |