a new method, hope it works

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

所有跟帖： 

• 真是個天才，也解決了我的一大難題。 -xyz100- ♂ (0 bytes) () 07/21/2010 postreply 13:36:21

• after "highlight these two cells," should "copy", then -西瓜炒成芝麻- ♂ (0 bytes) () 07/21/2010 postreply 14:38:25

• Cool. Thank you very much. -wxcqt- ♂ (0 bytes) () 07/22/2010 postreply 07:00:19