How to make filling of series refer to absolute cell?

[dylansmith]

as per this example. When I use the Fill function, the formula will use (A7+$F4..5...6...7)*1.04 instead of using F4 as absolute reference.



How do I fix this filling error?

[GIFCoach.com]

Hi,

The reason is that the $ sign in '$F4' locks only the column, and not the row. Therefore when you fill or copy down rows, the rows will change.

To prevent this, lock both the column and the row by using $F$4

[dylansmith]

amazing. u're a genius, thanks!