回复：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!