How to subtract a number from all the cells of a column in Excel win2suse 文学城

win2suse2007-04-25 08:15:59

I have tried my hand with formula like:
A1:A100-123
but doesn't work.

Any advice?

晕乎2007-04-25 09:08:05

manually input in one cell, than copy and paste to the others

win2suse2007-04-25 11:17:01

copy and paste->都成同一个值了

ppzcgg2007-04-25 16:23:46

paste special

毛毛爸2007-04-25 16:24:36

回复

继续阅读

何种外置硬盘MAC PC 通用？MACvs.PC 2007-04-25 05:00:51 求助; 系统日期问题指犹凉 2007-04-25 04:30:17 求救：Ad-aware扫描中途自己就停了，无法继续扫描。谢谢。 (图)13579. 2007-04-25 03:35:01 你不可不知的电脑专业术语 (转贴)墨斗鱼 2007-04-25 02:49:34 问题请教bld 2007-04-25 01:08:29 有谁知道用什么html code可以防止上传的PP被SAVE AS?IvyLi 2007-04-25 00:49:55 Mac OS 中删除错误词组？cindyelegance 2007-04-24 23:12:36 [转帖]分析人士：AMD快没钱了n 2007-04-24 23:16:31 网友制作好的Windows PE，基于Vista！anakin 2007-04-24 23:15:35 背熟以下文章，就能脱离鼠标，光用键盘操作了文且听风 2007-04-24 23:14:54

同作者

API for data acquisition and data visualization WANTETwin2suse 2008-04-22 20:40:07 半年的软件项目，通常的价格会是多少?win2suse 2008-04-09 18:14:27 software simulator 急急急win2suse 2008-03-11 21:35:56 template tex file for dissertationwin2suse 2007-11-29 10:14:13 穷学生买电脑，请高手推荐。win2suse 2007-10-14 16:18:08 怎样在Linux环境下格式化成FATwin2suse 2007-05-14 09:13:50 刚刚让网管装了Typhoon TV/FM PCI capture cardwin2suse 2007-05-10 13:30:20 How to subtract a number from all the cells of a column in Excelwin2suse 2007-04-25 08:15:59 HyperTerminal 不传数据???win2suse 2007-04-15 16:15:14 simple gui with opencv libwin2suse 2007-02-15 18:06:58