一个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