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

This method can let you use drag down to copy all formulas not matter how many row you have.

1. In cell A1 of the target sheet type =sheet1!A1, then drag down to copy formula.

2. In cell B1 of the target sheet type in the following formula: =IF((ROW()/2-INT(ROW()/2))>0,1,0). Then drag down to copy the formula to all cells. The value should be 1 if it is odd row, and 0 if it is even row.

3. Select column A and B in the target sheet, then go to menu Data->Filter->AutoFilter.

4. In column B set filter to equal to 0.Then delete all rows. The rest rows are the odd rows in original order.

5. Delete column B in the target sheet.

所有跟帖： 

• 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