I know this is probably a very basic question but hope someone can help. In
reference to copying formula... Lets say, for example that I have a number in
C1 and I want the items in A3, A4, A5.. to multiply times c1 and produce the
answer in B3, B4, B5.. I know the basic formula in B3 is =A3*C1 However if
i just copy that formula and paste it in B4 it changes the formula to =A4*C2
when I want it to keeo the C1. Does that make sense?

How do I keep the formula to keep referencing the C1 cell. I tried Paste
special, formula only, etc but it keeps carrying the formula down to C2 or C3.