fill series

[The Print King]

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?

 

[francis]

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]

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!