[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