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就固定了
https://cowlevel.net/article/1860271
也好想给我cp做文字游戏,如果有人写脚本的话我可以免费做! (然后可以预见的只有我和写脚本的人会去玩)
AO3: https://archiveofourown.org/users/AirGuitar/works
Privatter: https://privatter.net/u/RRgoGators
非粉红非反贼,无一定原创嘟或者太多键政内容不会通过,无需礼貌回fo