How to copy and paste the filtered table data?

November 23, 2021
86 Views 0

Graphic skills

1. Open your document and filter the data as needed. Here we take this sales table as an example. We want to know sales in Beijing and Shanghai.

How to copy and paste the filtered table data1.gif 

2. Select the cells to be copied after filtering. Click Ctrl+C and click Ctrl+V to paste in the targeted area.

How to copy and paste the filtered table data2.gif 

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.