fill series
 

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?

fill series
 

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

fill series
 

put an absolute reference to it
eg A2 would become $A$2, put your cursor at the cell reference
in the formula bar and press F4 key

so whenever you copy, $A$2 will remain unchange
for more info on absolute vs relative, check the Help in Excel

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










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

fill series
 

I knew there must be a way. Works perfect and will save me loads of time. I
only wish Microsoft help menus were as helpful as you! Spent the last hour
trying to find a solution, and you solved it in a minute. Thanks a million!

"jackgopher via OfficeKB.com" wrote:

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