一個Excel問題，可否拖拽產生數據

一個Excel問題，可否拖拽產生數據？
比如sheet2一個列，每一個單元的數據如下產生
=sheet1!A1
=sheet1!A3
=sheet1!A5
=sheet1!A7 ...
我如果選中上麵的單元向下拖拽，那麽產生的是連續的行數8/9/10/...... 而非我想要的單數 9/11/13/...
問，有什麽辦法拖拽產生, 還是我必須手工輸入？
謝謝。

所有跟帖： 

• Create 1st cell as "=sheet1!A1" -xyz100- ♂ (227 bytes) () 07/21/2010 postreply 09:49:53

• 回複：Create 1st cell as "=sheet1!A1" -wxcqt- ♂ (185 bytes) () 07/21/2010 postreply 11:05:05

• a new method, hope it works -西瓜炒成芝麻- ♂ (335 bytes) () 07/21/2010 postreply 13:23:59

• 真是個天才，也解決了我的一大難題。 -xyz100- ♂ (0 bytes) () 07/21/2010 postreply 13:36:21

• after "highlight these two cells," should "copy", then -西瓜炒成芝麻- ♂ (0 bytes) () 07/21/2010 postreply 14:38:25

• Cool. Thank you very much. -wxcqt- ♂ (0 bytes) () 07/22/2010 postreply 07:00:19

• 回複：一個Excel問題，可否拖拽產生數據 -jjbear- ♂ (682 bytes) () 07/21/2010 postreply 18:29:18

• Above is the most efficient way so far if you know how to use fi -jjbear- ♂ (0 bytes) () 07/21/2010 postreply 18:39:09

• There are data in other columns. I can not delete entire rows. -wxcqt- ♂ (208 bytes) () 07/22/2010 postreply 07:07:53

• Try this, it should work. -jjbear- ♂ (405 bytes) () 07/22/2010 postreply 09:10:26

• Yep, this is a smart way to just work on the two columns. Thanks -wxcqt- ♂ (0 bytes) () 07/22/2010 postreply 12:09:43

• Excellent. Can u help me to arrage the data from a column to a r -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 12:33:47

• 回複：Excellent. Can u help me to arrage the data from a column to -xyz100- ♂ (68 bytes) () 07/22/2010 postreply 12:35:17

• Use transpose -jjbear- ♂ (116 bytes) () 07/22/2010 postreply 15:13:35

• 瓦，這幕簡單呀? 謝謝，還真管用， -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 18:03:37

• 回複：一個Excel問題，可否拖拽產生數據 -以前的筆名忘了- ♂ (339 bytes) () 07/23/2010 postreply 12:16:51