You have to use what is called "Absolute Referencing" to keep that reference
fixed.
It is done by using the $ sign in the cell reference, for example, if you
have a formula like this:
=A1+B1
Then you can hold the Cell A1 fixed by changning it to:
=$A$1+B1

Have a look over here for a tutorial video about this (the fourth video named
"Understanding absolute and relative referencing"):
http://www.free-training-tutorial.com/formulas.html




The Print King wrote:
How do I keep specific cell references from advancing to incremental
references when using the fill. For example, when using the fill right
command it advances all cell coordinate references, which is ok for the most
part, but there is a cell reference which I want to remain unchanged. Does
anyone know if this can be done?

--
Message posted via http://www.officekb.com