[thelist] MS Excel Question

Gary McPherson genyus at ingenyus.net
Mon Aug 25 19:24:54 CDT 2003

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



More information about the thelist mailing list