View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Municorn1977 Municorn1977 is offline
external usenet poster
 
Posts: 6
Default formula, with constant cell, trouble with fill down

thanks

"Bob I" wrote:

$D$1


Municorn1977 wrote:
I have a cell with a fraction put to decimal. When I use this cell in a
function and I Fill Down the cell that is used moves.
Ex.
cell D1 has the fraction.
B1 has equation =A1*D1
and I Fill Down the equation ends up =A2*D2 and =A3*D3 and so on
How do I keep cell D1 when I use the Fill Down?