Copy Filtered Data (Visible Cells) in Excel & Google Sheets

This tutorial demonstrates how to copy filtered (visible) data  in Excel and Google Sheets.

 

copy filtered data 7

 

Copy Filtered Data

Say you have the following sales dataset and want to filter and copy only rows with Feb-21 in Column C (Month).

 

copy filtered data initial data

 

  1. First, turn on AutoFilter arrows to be able to filter data.
    Click anywhere in the data range, and in the Ribbon, go to Home > Sort & Filter > Filter.

 

copy filtered data 1

 

  1. Now, click on the AutoFilter icon in Column C heading, select February (under 2021), and click OK.

 

copy filtered data 2

 

  1. As a result of previous steps, only rows with the month Feb-2021 are filtered. To copy only visible cells, select the data range you want to copy (B1:D10), and in the Ribbon, go to Home > Find & Select > Go To Special…

 

copy filtered data 3

 

  1. In the Go To Special window, check Visible cells only, and click OK.

 

copy filtered data 4

 

  1. Now only visible cells (filtered data) are selected. Right-click anywhere in the selected area, and click Copy (or use the keyboard shortcut CTRL + C).

 

copy filtered data 5

 

  1. Right-click the cell where you want to paste the data, and choose Paste (or use the keyboard shortcut CTRL + V).

 

copy filtered data 6

 

This copies only the filtered data (Feb-21).

 

copy filtered data final data

 

Copy Filtered Data in Google Sheets

Say you have the following dataset and want to filter and copy only rows with the word Wireless in Column A (Product).

 

custom autofilter new 8

 

  1. First, turn on Filter arrows in order to filter data.  Click anywhere in the data range and in the Toolbar click on the Filter button.

 

custom autofilter new 2

 

2. Now, click on the Filter icon in the Column A heading, click on Filter by condition, and choose Text contains.

 

custom autofilter new 3

 

3. In the box enter the wanted text (in this example Wireless) and press OK.

 

custom autofilter new 5

 

As a result, only rows with the word Wireless will are filtered.

 

custom autofilter new 6

 

4. To copy only visible cells, select the data range you want to copy (A1:B6), right-click it, and choose Copy (or use CTRL + C shortcut).

 

copy filtered data visible cells new 5

 

5. Click on the cell where you want to paste the data, right-click on it and choose Paste.

 

copy filtered data visible cells new 6

 

As a result, only filtered data will be copied.

 

copy filtered data visible cells new 4