[thelist] MS Excel Question

Casey Crookston casey at thecrookstons.com
Mon Aug 25 16:46:33 CDT 2003


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?

TIA,

Casey




More information about the thelist mailing list