If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.

写公式里面有固定的项的话用$固定这样下拉应用的时候就不会变了!
比如, A1 + $B$1,B1就固定了

cowlevel.net/article/1860271

也好想给我cp做文字游戏,如果有人写脚本的话我可以免费做! :blobcathyper: (然后可以预见的只有我和写脚本的人会去玩)

呜呜 w(> ʌ <)w

一个 泛ACGN 实例,讨论主题不限 ~