問題已解決
這個含有公式怎么復(fù)制粘貼到另一個Excel表格利
![](https://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/013/71/04/64_avatar_middle.jpg?t=1651217497)
學(xué)員你好,你是想把公式也復(fù)制過去還是只要數(shù)值
2022 05/14 07:10
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784957 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 05/14 07:12
不要公式
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784957 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 05/14 07:14
只要數(shù)值也會把其它隱藏的數(shù)據(jù)帶出來我復(fù)制過去的話
![](https://pic1.acc5.cn/013/71/04/64_avatar_middle.jpg?t=1651217497)
悠然老師01 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 05/14 07:21
把其他數(shù)據(jù)隱藏后復(fù)制,選擇性粘貼
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784957 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 05/14 07:23
我用公式算的,已經(jīng)隱藏了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784957 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 05/14 07:24
選擇性黏貼也不行
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84784957 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 05/14 07:24
會把隱藏部分帶出來
![](https://pic1.acc5.cn/013/71/04/64_avatar_middle.jpg?t=1651217497)
悠然老師01 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 05/14 07:28
那就復(fù)制工作表,然后選擇性粘貼數(shù)值后在隱藏
![](/wenda/img/newWd/sysp_btn_eye.png)