問題已解決
老師,I列是我篩選出來的,我想把篩選后F列的數(shù)字粘貼到D列怎么操作呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
你好,篩選后的數(shù)據(jù)復制時要先按ALT加; 這樣就定位出可見單元格了,然后復制粘貼
2018 12/28 11:35
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785012 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/28 16:17
謝謝老師
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785012 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/28 16:17
老師,我的excel加密了,怎么取消密碼呢
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
王銀花老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2018 12/28 18:55
你好你是加的打開密碼還是簡單的保護工作表的密碼,怎樣設置的就可以怎樣取消的!
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785012 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/29 08:34
打開密碼
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785012 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2018 12/29 08:35
之前是別人加密的,我也不清楚怎么加的
![](/wenda/img/newWd/sysp_btn_eye.png)