回複：excel運用'auto filter' 功能的時候，如果僅

來源: 於 2005-09-03 20:45:02 [舊帖] [給我悄悄話] 本文已被閱讀：次

U can do it. From the Menu, do the following.

Edit/GO TO/SPECIAL/VISIBLE CELLS ONLY

Then copy/paste.

You can also use pivot or advanced filter. Good luck!