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