Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can u add cells in Excel without pressing "shift +" one by one?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Can u add cells in Excel without pressing "shift +" one by one?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing grouping in Excel I get "Cannot shift objects off sheet"? Nasty Merasty Excel Discussion (Misc queries) 1 February 1st 08 05:16 PM
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" MikeElstonJones Excel Discussion (Misc queries) 3 November 28th 07 12:42 PM
Excel error "Cannot shift objects off sheet", can I fix? LionHearted1952 Excel Discussion (Misc queries) 1 September 30th 06 05:27 PM
colour fonts revert to black when pressing "Enter" BAB Excel Discussion (Misc queries) 5 February 22nd 06 06:45 PM
How do I turn on "pressing enter goes to the next cell" option? Hollywood Excel Discussion (Misc queries) 6 December 20th 05 09:10 PM


All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"