关于自动填充问题(On the problem of automatic filling)

%3CLINGO-SUB%20id%3D%22lingo-sub-2487425%22%20slang%3D%22zh-CN%22%3EOn%20the%20autofill%20issue%20(On%20the%20problem%20of%20automatic%20filling)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2487425%22%20slang%3D%22zh-CN%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yunpeng_Shen_0-1624675939423.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F291556i5D64D9E4010654D8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yunpeng_Shen_0-1624675939423.png%22%20alt%3D%22Yunpeng_Shen_0-1624675939423.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFigure%20shows%20that%20the%20total%20amount%20of%20the%20loan%20corresponds%20to%20F32%3AF95%20x%20L5%2C%20L5%20is%20fixed%20but%20when%20the%20K%20column%20is%20automatically%20filled%20down%2C%20L5%20will%20change%20to%20L%20plus%20other%20numbers%2C%20how%20to%20solve%20this%20problem%3C%2FP%3E%3CP%3EAs%20shown%20in%20the%20figure%2C%20the%20total%20amount%20of%20the%20loan%20corresponds%20to%20F32%2C%20the%20loan%20F95%2C%20the%20L5%2C%20the%20L5%20is%20fixed%2C%20but%20when%20the%20drop-down%20K%20column%20is%20automatically%20filled%2C%20the%20L5%20will%20be%20changed%20to%20L%20%2B%20other%20numbers%2C%20how%20to%20solve%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2487425%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2487480%22%20slang%3D%22en-US%22%3ERe%3A%20%E5%85%B3%E4%BA%8E%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%E9%97%AE%E9%A2%98%EF%BC%88On%20the%20problem%20of%20automatic%20filling%EF%BC%89%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2487480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1088539%22%20target%3D%22_blank%22%3E%40Yunpeng_Shen%3C%2FA%3E%26nbsp%3BYou%20may%20fix%20the%20reference%20to%20L5%20by%20making%20it%20absolute%2C%20i.e.%20place%20dollar%20signs%20in%20front%20of%20the%20Column%20and%20Row%20references.%2C%20like%20so%3A%20%3CSTRONG%3E%24L%245%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

Yunpeng_Shen_0-1624675939423.png

 

如图贷款总额对应的是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