回複：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

請您先登陸，再發跟帖！