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

anybody tried index function? try using this formula in sheet 2. In sheet2 cell A1 =index(Sheet1!$A$1:$A$10000,row(a1)*2-1), and then drag down to whatever number of cells you want. This is truely what you need. one simple formula, and values update as your sheet1 data changes. No sorting, no multiple pasting, no extra column needed.