[thelist] MS Excel Question

Chris W. Parker cparker at swatgear.com
Mon Aug 25 18:55:24 CDT 2003

Casey Crookston <mailto:casey at thecrookstons.com>
    on Monday, August 25, 2003 2:47 PM said:

> 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?

You have to put a $ in front of the thing you don't want to change.



That will allow the columns to change when dragged left/right.


That will allow the rows to change when dragged up/down.


That will not allow either value to change regardless of which way it is


More information about the thelist mailing list