[thelist] MS Excel Question

[Gary McPherson]

thelist-bounces at lists.evolt.org wrote:
> When creating a formula in Excel you can, of course, reference other
> cells: 
> 
> =b15+c15
> 
> If you copy and paste that cell, Excel is kind enough to
> change the cell references relative to where you pasted.  But
> what if I want one of the cell references to remain constant? 
> Example: 
> 
> Original:    =B15+C15
> Pasted:    =B16+C15
> Pasted:    =B16+C15
> Pasted:    =B16+C15
> Pasted:    =E16+C15
> 
> How do you specify that C15 is to remain unchanged?
> 

An absolute cell reference, which looks like $C$15. So your formula
would be =B16+$C$15

HTH,

Gary