问题已解决
老師我怎么對篩選完的數(shù)據(jù)對可見單元格進行復制粘貼呢,操作總不成功呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/08/79/25_avatar_middle.jpg?t=1714030903)
你好,隱藏單元格的可以復制,不能粘貼的
2020 11/10 09:09
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/10 09:14
老師我這個是篩選出來的數(shù)據(jù),我要單獨的數(shù)據(jù) 如何復制粘貼
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/10 09:15
就是只要可見單元格的數(shù)據(jù)
![](https://pic1.acc5.cn/011/08/79/25_avatar_middle.jpg?t=1714030903)
冉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 11/10 09:18
這個可以,選中篩選的單元格,然后Ctrl+c,然后重新開一個sheet表,Ctrl+v即可
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/10 09:19
就是總也選不中啊
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/10 09:19
這么多行我不能一行一行選中啊
![](https://pic1.acc5.cn/011/08/79/25_avatar_middle.jpg?t=1714030903)
冉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 11/10 09:28
你用ctrl+shit+向下箭頭快捷鍵選不中?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84785046 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 11/10 09:32
老師您沒明白我的意思,我是對原數(shù)據(jù)按條件進行了篩選,這是篩選后的數(shù)據(jù) 我要生成一個新的數(shù)據(jù)表
FAILED
![](https://pic1.acc5.cn/011/08/79/25_avatar_middle.jpg?t=1714030903)
冉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 11/10 09:34
這個可以的,如果新生產(chǎn),你要全選中,CRTL+A也可以,然后復制,在重新一個表格中復制就可以
![](/wenda/img/newWd/sysp_btn_eye.png)