How to Copy & Paste Filtered Data

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

It is possible to filter data in Microsoft Excel. When doing this, much of the original data is no longer visible and instead you see only a subset of the spreadsheet. You may wish to copy these filtered results and paste them elsewhere, such as into another spreadsheet. This process varies depending on the version of Excel you use, but it is straightforward either way. You can then create a new data set that includes only the filtered data from the original spreadsheet.

Advertisement

Step 1

Drag your mouse over the filtered data so it is highlighted. This identifies to the program which data you wish to copy.

Video of the Day

Step 2

Press the "F5" button on your computer keyboard, if you are using Excel 2007 or later. A pop-up window will appear. Alternately, you can click the "Go To" button in the "Find & Select" section of the Excel toolbar. This step is not necessary for versions of Excel prior to 2007.

Advertisement

Step 3

Click the "Special" button on the pop-up window.

Step 4

Click the "Visible cells only" option, and press "OK". This instructs Excel to only select the data included in the filtered results. Hidden data from the original unfiltered data set is ignored. You are now ready to copy.

Advertisement

Advertisement

Step 5

Press the Control-C keyboard combination to copy the data. Alternately, select the "Copy" button on the Excel toolbar.

Step 6

Click on the spreadsheet, file, or other document where you wish to paste the filtered data.

Step 7

Press the Control-V keyboard combination to paste. The filtered data is pasted into the new file.

Video of the Day

Advertisement

Advertisement

references