How to filter and copy office 2007? Today I will share the method of filtering and copying office 2007. If you are in need, please learn with me.
First, select a data table, as shown in the figure, our purpose is to copy the item with data 2

Then, we filter data 2, as shown in the figure

Next, we select the filtered data, and then press alt+; that is, hold down the ALT key and the semicolon key at the same time, and a shadow will appear on the selected part, as shown in the figure

Finally, press ctrl+c to copy, and then press ctrl+v to paste it into another table.

The above is the office 2007 filtering and copying method that the editor brought to Ali. Let’s learn it together. I believe it can help some new users.