How to Copy and Paste Filtered Data in Excel: A Step-by-Step Guide

Copying and pasting filtered data in Excel can be a bit tricky if you don’t know the right steps. Essentially, you need to ensure that only the visible data—after applying filters—is copied over to the new location, without grabbing any hidden rows. Don’t worry, it’s easier than it sounds! Here’s a foolproof guide to make sure you get it right.

Step-by-Step Tutorial on How to Copy and Paste Filtered Data in Excel

This step-by-step guide will walk you through the process of copying and pasting only the data that you have filtered in an Excel spreadsheet.

Step 1: Select the Filtered Data

Click and drag to select the cells that are visible after you’ve applied your filters.

Make sure that you only select the visible cells. You should see the rows that don’t meet the filter criteria disappear, making it easier to select just the filtered data.

Step 2: Open the Go To Special Dialog Box

Press Ctrl + G on your keyboard, then click on "Special…" to open the Go To Special dialog box.

This step ensures that you’re selecting only the visible cells and not the hidden ones. The Go To Special feature is a hidden gem many people overlook!

Step 3: Choose Visible Cells Only

In the Go To Special dialog box, choose “Visible cells only” and click OK.

This tells Excel to copy only the cells that you can see, ignoring any hidden ones. It’s a crucial step to make sure that your data isn’t muddled with hidden information.

Step 4: Copy the Selected Cells

Press Ctrl + C to copy the selected, visible cells.

This standard copy command will now only include the visible cells thanks to the previous steps. You can also right-click and choose ‘Copy’ if you prefer.

Step 5: Paste the Data

Navigate to the new location where you want to paste the data and press Ctrl + V.

This will paste only the visible cells into the new location, keeping your data clean and organized. Easy peasy!

Once you complete these steps, your filtered data will be copied and pasted into the new location without any hidden rows. You’ve successfully moved just the data you wanted!

Tips for Copying and Pasting Filtered Data in Excel

  • Make sure your filters are correctly applied before you start selecting data.
  • Use Ctrl + G to quickly access the Go To Special dialog box.
  • Remember to choose "Visible cells only" to avoid copying hidden rows.
  • Use keyboard shortcuts like Ctrl + C and Ctrl + V to speed up the process.
  • Double-check the pasted data to ensure no hidden rows were accidentally included.

Frequently Asked Questions

What if I accidentally copy hidden rows?

If you accidentally copy hidden rows, you can undo the action by pressing Ctrl + Z and then follow the steps more carefully.

Can I use the right-click menu to access the Go To Special dialog box?

Yes, you can right-click on the selected cells, choose "Go To Special," and then select "Visible cells only."

Will this method work for copying data to another workbook?

Absolutely! Just make sure you follow the same steps, and you can paste the data into any workbook you like.

Is there a way to automate this process using a macro?

Yes, you can use VBA macros to automate copying and pasting of filtered data, but that’s a more advanced topic.

Can I use this method to copy and paste filtered data into a different software?

Yes, once you have copied the filtered data, you can paste it into different software like Word or even an email.


  1. Step 1: Select the Filtered Data
  2. Step 2: Open the Go To Special Dialog Box
  3. Step 3: Choose Visible Cells Only
  4. Step 4: Copy the Selected Cells
  5. Step 5: Paste the Data


Copying and pasting filtered data in Excel might sound complicated at first, but once you know the steps, it’s a breeze. The key is to ensure that you’re only copying the visible cells and not accidentally grabbing any hidden rows. By following the steps outlined in this guide, you can ensure your data stays clean and accurate.

These techniques are particularly useful for cleaning up large datasets, preparing reports, or moving data between different sheets or workbooks. Mastering this skill can save you a lot of time and headaches.

For further reading, you might want to delve into Excel’s wide array of data manipulation tools or even look into automating routine tasks with macros. Happy Excel-ing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy