问题已解决
这个含有公式怎么复制粘贴到另一个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)
学员你好,你是想把公式也复制过去还是只要数值
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
只要数值也会把其它隐藏的数据带出来我复制过去的话
![](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
把其他数据隐藏后复制,选择性粘贴
![](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
我用公式算的,已经隐藏了
![](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
那就复制工作表,然后选择性粘贴数值后在隐藏