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.
回複:一個Excel問題,可否拖拽產生數據
所有跟帖:
•
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