Here’s how to copy and paste visible cells only in Excel:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Let’s say I have a table of sales by month for 2013, and I only want to copy and paste the first quarter and total to another area of the worksheet:
I hide the columns I don’t want to copy, highlight the visible area, and use the keyboard shortcut Ctrl + C:
As you can see, it only put the “dancing ants” around the entire area, so when I paste it, Excel pastes not only what was visible, but all the cells in the highlighted area:
Alternatively, prior to copying the area, after highlighting it, use the keyboard shortcut Alt + ; (Alt key plus the semicolon). Then when you copy the data, it will only highlight the visible cells:
Now, when you paste it, only those cells that were visible are copied and pasted:
This will obviously work for hidden rows as well: