Thread: Easy to do but cannot remember how!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chivalrous1 Chivalrous1 is offline
external usenet poster
  
Posts: 2
Default Easy to do but cannot remember how!
A B
1 SUM(A1)
2 SUM(A1:A2)
3 SUM(A1:A3)
4
5
6
7

Question is, how do I fill down so that A1 stays as a constant? When I
hightlight and drag it will just add to the A1.

Reply With QuoteReply With Quote