Create 1st cell as "=sheet1!A1"

來源: 於 2010-07-21 09:49:53 [博客] [舊帖] [給我悄悄話] 本文已被閱讀：次

leave 2nd cell blank. then copy the two cells and paste the two cells below the 1st 2 cells. it will generate 1, 3, 5, 7, lines only, but with empty lines between them.
U can then delete these empty lines.

Newbie user