新西兰天维网社区

标题: Excel pro please help~~! [打印本页]

作者: yzphb 时间: 2010-11-8 14:34:35 标题: Excel pro please help~~!

Got a issue today,,when dragging one formulaed cell, how to make only one number change and another fix?

For example: a cell formulaed as A1*B1, when dragging through, normally it comes to B1*C1, C1*D1, D1*E1............

My question is, how to make only A1 change to B1..C1 and so on when dragging through but B1 stay the same for all cell?.....

Sorry can not type in Chinese and really, really appreciate for this!!!

作者: yossarian 时间: 2010-11-8 14:38:16

------------------------$B$1------------------------------------

作者: yzphb 时间: 2010-11-8 14:40:24

------------------------$B$1------------------------------------
yossarian 发表于 2010-11-8 14:38

You are the MAN bro!!

Cheers!!

作者: 荒岛余生 时间: 2010-11-8 16:40:55

选中B1，然后按F4

作者: fallrainsboy 时间: 2010-11-8 16:52:17

$固定column 或Row

欢迎光临新西兰天维网社区 (http://bbs.skytrade.co.nz/)