Forum Discussion
关于自动填充问题（On the problem of automatic filling）
如图贷款总额对应的是F32:F95*L5，L5是固定不变的但是下拉K列自动填充时，L5会变动成L+其他数字，如何解决这个问题
As shown in the figure, the total amount of the loan corresponds to F32, the loan F95, the L5, the L5 is fixed, but when the drop-down K column is automatically filled, the L5 will be changed to L + other numbers, how to solve this problem?
1 Reply
Yunpeng_Shen You may fix the reference to L5 by making it absolute, i.e. place dollar signs in front of the Column and Row references., like so: $L$5
