Jun 25 2021 07:53 PM
如图贷款总额对应的是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?
Jun 25 2021 09:01 PM
@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