標題:

關於excel...

發問:

由A1~Z1 同A1~A17 每個格入面都有數字 宜家要張所有數字+100000 有咩方法可以一次過張每個格入面既數字+100000?? 唔該!!

免費註冊體驗

 

此文章來自奇摩知識+如有不便請留言告知

最佳解答:

I assume the first page of your spreadsheet is call "Sheet1" Go to Sheet2 In the first cell, enter "=Sheet1!A1+100000" Then use the fill function (Edit --> Fill) to fill up 17 rows down, then fill right until it reach Z17. Or the shortcut is, highlight the first cell, put your cursor right on the right lower corner of the highlighted cell, once you see the "cross" icon, drag that to A17. Then highlight A1 - A17, do the same thing to fill out the entire sheet until Z17. Hope this help.

其他解答:
創作者介紹
創作者 香港美食2017 的頭像
香港美食2017

香港美食2017

香港美食2017 發表在 痞客邦 留言(0) 人氣()