[算表] 超多筆向下填滿請益。
軟體:EXCEL
版本:公司使用2010
誠心請教要怎麼把超多筆的資料(B欄至P欄)向下填滿(如圖):
http://imgur.com/a/a2kuQ
我都是一筆一筆的敲,
Ctrl+↓
Shift+Ctrl+→
Shift+Ctrl+↓
Shift+↑
Ctrl+D
以上一筆完成,然後下略好幾千筆(4、5000筆)
每天自己處理這些資料都花了好多時間,
自己錄製以上操作的巨集也都跟自己手做的不一樣,
再向版友們請教了謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.25.36.98
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1472739002.A.472.html
推
09/02 00:20, , 1F
09/02 00:20, 1F
推
09/02 00:45, , 2F
09/02 00:45, 2F
→
09/02 00:47, , 3F
09/02 00:47, 3F
→
09/02 00:48, , 4F
09/02 00:48, 4F
→
09/02 00:48, , 5F
09/02 00:48, 5F
→
09/02 00:49, , 6F
09/02 00:49, 6F
推
09/02 00:54, , 7F
09/02 00:54, 7F
推
09/02 01:32, , 8F
09/02 01:32, 8F
→
09/02 01:32, , 9F
09/02 01:32, 9F
→
09/02 01:37, , 10F
09/02 01:37, 10F
→
09/02 01:37, , 11F
09/02 01:37, 11F
→
09/02 01:38, , 12F
09/02 01:38, 12F
→
09/02 01:39, , 13F
09/02 01:39, 13F
→
09/02 01:49, , 14F
09/02 01:49, 14F
→
09/02 01:49, , 15F
09/02 01:49, 15F
→
09/02 01:49, , 16F
09/02 01:49, 16F
→
09/02 01:50, , 17F
09/02 01:50, 17F
→
09/02 01:50, , 18F
09/02 01:50, 18F
→
09/02 01:50, , 19F
09/02 01:50, 19F
→
09/02 01:51, , 20F
09/02 01:51, 20F
→
09/02 01:51, , 21F
09/02 01:51, 21F
→
09/02 01:59, , 22F
09/02 01:59, 22F
→
09/02 02:00, , 23F
09/02 02:00, 23F
→
09/02 02:04, , 24F
09/02 02:04, 24F
→
09/02 02:05, , 25F
09/02 02:05, 25F
→
09/02 02:05, , 26F
09/02 02:05, 26F
→
09/02 02:06, , 27F
09/02 02:06, 27F
→
09/02 02:06, , 28F
09/02 02:06, 28F
→
09/02 02:07, , 29F
09/02 02:07, 29F
→
09/02 02:07, , 30F
09/02 02:07, 30F
→
09/02 02:08, , 31F
09/02 02:08, 31F
→
09/02 02:08, , 32F
09/02 02:08, 32F
→
09/02 02:08, , 33F
09/02 02:08, 33F
→
09/02 02:09, , 34F
09/02 02:09, 34F
→
09/02 02:10, , 35F
09/02 02:10, 35F
→
09/02 02:10, , 36F
09/02 02:10, 36F
→
09/02 02:10, , 37F
09/02 02:10, 37F
→
09/02 02:11, , 38F
09/02 02:11, 38F
→
09/02 02:12, , 39F
09/02 02:12, 39F
推
09/02 02:26, , 40F
09/02 02:26, 40F
→
09/02 08:08, , 41F
09/02 08:08, 41F
討論串 (同標題文章)