View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bapeltzer bapeltzer is offline
external usenet poster
 
Posts: 43
Default Focing a cell to be used

Use an absolute reference. Where you now have b1, use $b$1.
(There are also mixed references. $b1 would keep the column fixed as you
copy across; b$1 would keep the row fixed as you copy down).

"NAUBryan" wrote:

Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1)
1200*a2^(b1)
.
.
.
1200*an^(b1)
the way it stand now, draging the equation leads to both cells roaming. I
want to fix one cell. The question is how.