a new method, hope it works

来源: 于 2010-07-21 13:23:59 [博客] [旧帖] [给我悄悄话] 本文已被阅读：次

In the first cell, type: "=sheet1!A1"

in the cell below, type number "1"

highlight these two cells,

paste up to all the rows you want in the same column(has to be even number)

then select the whole column

Go to Edit>GoTo>Special>Constants>OK

Go to Edit>Delete>OK

Hope it works