How to Copy & Paste Filtered Data

By James Highland

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.

Step 1

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

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.

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.

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.