回复：excel运用'auto filter' 功能的时候，如果仅

来源: exceldana 于 2005-09-03 20:45:02 [] [旧帖] [给我悄悄话] 阅读数 : (175 bytes)

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!

所有跟帖： 

• 如何用‘advanced filter‘’来解决呢？谢谢 -jq_jou- ♀ 给 jq_jou 发送悄悄话 (0 bytes) () 09/04/2005 postreply 08:50:48

• 回复：如何用‘advanced filter‘’来解决呢？谢谢 -exceldana- ♀ 给 exceldana 发送悄悄话 (199 bytes) () 09/04/2005 postreply 20:40:08

请您先登陆，再发跟帖！