Copy only the visible cells in Excel

Have you experienced copying a filtered data from a table and when you paste it, it pasted even the hidden data? It's frustrating, right? By default, Excel copies even the hidden rows in filtered table. If you only want to copy the visible or the filtered data, today I'm going to teach how to do that. Just follow these simple steps:

1. Select the cells you want to copy.

2. Now go to the Ribbon. Go to the HOME tab, then EDITING group and click FIND & SELECT.
   

3. Click GO TO, then click  Special...



4. Select Visible Cells Only", then click OK


5. On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut  You can also press CTRL+C.

6. Select the upper-left cell of the paste area.

 Tip   To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

7. On the Home tab, in the Clipboard group, click Paste .

Keyboard shortcut  You can also press CTRL+V.

*Applies to Excel 2007, Excel 2010 and Excel 2013