Hi!

I have a function in the function bar of my excel spreadsheet, and it
works well, and here is part of it:

=(F4/Constants!B1)+(G4*Constants!B4)

Now that is great, but I don't want to type it everytime for 50 rows
like F5/Constants!B1 F6/Constants!B1 So I grab the corner of the cell
and drag it down all the cells I want to have this function, and Excel
is smart enough to increment F4, F5, F6 etc across all the cells I
want.

Great! But Excel is not smart enough to tell that Constants!B1 is
constant, and should not change, and should not imcrement but stay B1
everytime. I tried to set 2 cells as I wanted, with B1 being the same,
and thought that might work, but it does not, I get the pattern B1 B1
B3 B3 B5 B5...you can take it from there.

So! Excel is not smart enough to know Constants!B1 should not change, I
am not smart enough to tell Excel how to do it, so I am looking for
someone smarter than the both of us put together to help me with my
problem!

To sum up, I would like to auto-complete a function, by dragging the
bottom right corner of a cell that has a function in it, down many
cells(I wish I knew what this was called) I would like some of the cell
designations to icriment(F4, F5, F6) but others to stay the same(B1,
B1, B1).

Any hints, help, or comments would be appriciated.