easy:

来源: 鸡毛蒜皮 于 2005-10-06 05:30:00 [] [旧帖] [给我悄悄话] 阅读数 : (326 bytes)

insert a colume first by the colume that has the data you want to modify. Let's say the colume A has the data, colume B is the new colume. In the first cell of colume B (say it is B1), type =A1-100.
Copy B1 and paste it to all other cells of the colume B. It's done.
You may delete colume A afterwards if you like.

所有跟帖： 

• you can not delete column A -xfyfz- ♀ 给 xfyfz 发送悄悄话 (302 bytes) () 10/06/2005 postreply 05:44:55

• thanks! You are right. -鸡毛蒜皮- ♀ 给 鸡毛蒜皮 发送悄悄话 (0 bytes) () 10/06/2005 postreply 05:51:50

• np :-p -xfyfz- ♀ 给 xfyfz 发送悄悄话 (0 bytes) () 10/06/2005 postreply 05:53:53

• 回复：easy: -tofuTnT- ♀ 给 tofuTnT 发送悄悄话 (143 bytes) () 10/06/2005 postreply 07:50:18

• 更胜一筹,谢谢! -鸡毛蒜皮- ♀ 给 鸡毛蒜皮 发送悄悄话 (0 bytes) () 10/06/2005 postreply 08:15:16

• 回复：easy: -钟国仁- ♂ 给 钟国仁 发送悄悄话 (23 bytes) () 10/06/2005 postreply 18:59:14

请您先登陆，再发跟帖！