View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default how to quick calculate sum of colume A1 to A115?

Anthony B wrote:
How to quick calculate sum of colume A1 to A115?

Or, do I always have to set up formular =sum(A1:A15) to get the sum?


I see you have several suggestions but for me the quickest is select
A1 then move your cursor to the bottom of the cell and you will get a
symbol with 4 points, hold the shift key and double click. This will
highlight A1 through A115 then hit the sum icon. It's the symbol that
looks kind of link an E(sigma sign).

gls858