[算表]excel能自動key資料嗎
請問有沒有方法能快速把資料鍵入excel的表格內
例如 資料是
3342
3344
3346
4368
4369
5269
6389
我想把
3342鍵入表格A1欄
3346鍵入表格B1欄
4368鍵入表格A2
4369鍵入表格B2
5269鍵入表格A3和B3
6389鍵入表格A4和B4
想請問有沒有自動鍵入的方法謝謝
軟體:
版本:
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.14.39.204
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1444535168.A.7B1.html
→
10/11 11:57, , 1F
10/11 11:57, 1F
→
10/11 12:04, , 2F
10/11 12:04, 2F
→
10/11 12:07, , 3F
10/11 12:07, 3F
→
10/11 12:11, , 4F
10/11 12:11, 4F
→
10/11 12:36, , 5F
10/11 12:36, 5F
→
10/11 14:29, , 6F
10/11 14:29, 6F
→
10/11 15:58, , 7F
10/11 15:58, 7F
→
10/11 15:59, , 8F
10/11 15:59, 8F
→
10/11 16:00, , 9F
10/11 16:00, 9F
→
10/11 16:11, , 10F
10/11 16:11, 10F
→
10/11 16:12, , 11F
10/11 16:12, 11F
→
10/11 16:30, , 12F
10/11 16:30, 12F
→
10/11 16:34, , 13F
10/11 16:34, 13F
→
10/11 16:34, , 14F
10/11 16:34, 14F
→
10/11 16:35, , 15F
10/11 16:35, 15F
→
10/12 06:20, , 16F
10/12 06:20, 16F
※ 編輯: pradaad (114.25.56.45), 10/12/2015 18:02:54