How to copy filtered data in excel
Tutor 5 (273 Reviews)
Excel Tutor
Still stuck with a Excel question
Ask this expertAnswer
To copy filtered data in Excel, follow these steps carefully:
-
Apply a Filter
Select the data range you want to filter.-
Go to the Data tab.
-
Click Filter. Small dropdown arrows appear in the header row.
-
Click the arrow on the column you want to filter and select your criteria. Only rows matching the criteria remain visible.
-
-
Select the Visible Data
Highlight the filtered data by clicking and dragging over the rows you want to copy. Ensure that only the visible rows are selected. -
Copy Only Visible Cells
Windows: Press Alt + ; to select visible cells only.
Mac: Press Command + Shift + Z to select visible cells only.
This step is crucial because copying without selecting visible cells will include hidden rows. -
Copy the Data
Press Ctrl + C (Windows) or Command + C (Mac) to copy the selected visible cells. -
Paste the Data
Navigate to the location where you want to paste.
Press Ctrl + V (Windows) or Command + V (Mac) to paste only the visible data.
Notes:
-
Copying without selecting visible cells may result in hidden rows being copied.
-
This method works for ranges, tables, and even filtered columns.
-
To quickly select all visible cells in a filtered range, you can also use the Go To Special option:
-
Press F5 or Ctrl + G to open the Go To dialog.
-
Click Special…
-
Choose Visible cells only
-
Click OK
-
This process ensures only the filtered data is copied, avoiding extra hidden rows.
. Was this Helpful?Related Questions
Get Online Tutoring or Questions answered by Experts.
You can post a question for a tutor or set up a tutoring session
Answers · 1
How to sort by highlighted cells in excel
Answers · 1
How to sort excel by column and keep rows together
Answers · 1
How to sort by time in excel
Answers · 1
How to sort alphabetically in excel by last name
Answers · 1