第1个回答 2013-08-12
这个目前有一个变通的方法,直接复制不行的。思路是:先保持原始数据的顺序不变,插入一辅助列,插入升序序号,再在后面插入一辅助列,然后在你筛选出来的单元格中输入一个数字,比如1.然后根据后加的辅助列排序。这样,你要筛选的内容就排列到一起了。这时你可以复制粘贴。粘贴完成后,再按前面插入的列升序排序,也就是恢复到原来的顺序。本回答被网友采纳
第2个回答 2017-11-20
直接粘贴做不到,建议用引用函数(如vlookup),再向下填充公式,如下:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acaf6873865b77d98d1000e99c81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb1327c32fb4d654564e93584bea?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6c224f4a20a446230086b7c59322720e0df3d7cc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a60593ec9febd2334349b023bbabf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d381656aa39c0a304e241f58d5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d00264bd18abec08fa513dc63b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/38dbb6fd5266d016afff878f9c2bd40734fa35b6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳
第3个回答 2016-01-21
EXCEL中,要对筛选后的数据进行替换操作,应遵循先选中后操作的方法,具体步骤如下:
1、选中筛选结果区域。
2、按F5或CTRL+G快捷键,调出定位对话框。
3、点击定位条件,选择可见单元格,单击确定。
4、这时再进行复制操作即可。
5、在EXCEL中,要对筛选结果进行其他操作,都可以使用此方法,先对筛选结果选中。本回答被网友采纳
第4个回答 2013-08-12
1、筛选出要复制的数据,2、点击编辑中的定位,3、点击定位条件,4、选中可见单元格后确定,5、右击鼠标复制再粘贴就好了