How to Copy & Paste Filtered Data

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

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

Step

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

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

Step

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

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

Step

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

Step

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