Excel Excel query

B

billiards

Joined
Aug 23, 2008
Messages
3
Reaction score
0
Hi, Its been a while since I used Excel, but I recently bought the Office Home and Student edition.

My query is, I want to use the 'Fill down' function. I have the following:

=SUM(B7+25.4)+C1
=SUM(B8+25.4)+C1

All I am wanting to do, is increase the 'B' value by one, in the next twenty five cells. But when I highlight these two cells, drag down the 25 cells, and use Fill, the 'C' value increases by one also.

Any ideas?
 
I have managed to work this out now. Just in case anyone is interested:


=SUM(B7+25.4)+C$1
The addition of a 'dollar' sign before the 1.
 
Back
Top