一个Excel问题，可否拖拽产生数据 wxcqt2010-07-21 15:25:40

一个Excel问题，可否拖拽产生数据？
比如sheet2一个列，每一个单元的数据如下产生
=sheet1!A1
=sheet1!A3
=sheet1!A5
=sheet1!A7 ...
我如果选中上面的单元向下拖拽，那么产生的是连续的行数8/9/10/...... 而非我想要的单数 9/11/13/...
问，有什么办法拖拽产生, 还是我必须手工输入？
谢谢。

Create 1st cell as "=sheet1!A1"

回复：Create 1st cell as "=sheet1!A1"

a new method, hope it works

真是个天才，也解决了我的一大难题。

after "highlight these two cells," should "copy", then

回复：一个Excel问题，可否拖拽产生数据

Above is the most efficient way so far if you know how to use fi

Cool. Thank you very much.

There are data in other columns. I can not delete entire rows.

Try this, it should work.

Yep, this is a smart way to just work on the two columns. Thanks

Excellent. Can u help me to arrage the data from a column to a r

回复：Excellent. Can u help me to arrage the data from a column to

Use transpose

瓦，这幕简单呀? 谢谢，还真管用，

回复：一个Excel问题，可否拖拽产生数据