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.