View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Formulas won't drag down the column

$a$20

--
Don Guillett
SalesAid Software

"Sara" wrote in message
...
I have created a spreadsheet in there are values in A1-A10, D1-D10, etc. ,
then I have a constant value in A20. I then created a formula A1*A20 in
cell
B1, and I would like to drap this formula down so that I get the following
result A2*A20, A3*A20...but when I drag the formula it gives me A2*A21,
A3*A22, A4*A23...Somebody please help!!!