[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.
i.e.
=B$15+C$15
That will allow the columns to change when dragged left/right.
=$B15+$C15
That will allow the rows to change when dragged up/down.
=$B$15+$C$15
That will not allow either value to change regardless of which way it is
drug(dragged?).
Chris.
More information about the thelist
mailing list