[thelist] MS Excel Question

[Paul Cowan]

Casey wrote:
> When creating a formula in Excel you can, of course, reference other
> cells:
>
> =b15+c15

<snip>

> How do you specify that C15 is to remain unchanged?

If you want the column (C) to remain constant, even if you paste into
another column, it's:
	=b15+$c15

If you want the row (15) to remain constant, even if you paste into
another row, it's:
	=b15+c$15

If you always want c15, no matter where it ends up, it's
	=b15+$c$15

Paul