How to copy and paste only visible cells in Excel – Guide
If you copy a range of cells that contain hidden rows or columns, Excel will include ALL selected rows. It doesn’t matter if they are visible or hidden. When you paste the range, all cells in the selection are pasted. This is really a good one feature, but it is not always what we expect. Sometimes we just want to copy and paste the visible cells and delete the hidden rows and columns. This usually happens when you are working with an area that has filters applied. Or if you have hidden rows or columns from a group collapsed into an outline. The subtotals feature automatically creates groupings of lines, which can result in hidden lines, as shown in the example above. Note: The method used to hide the lines does not affect how this technique works. You can use filters or right-click the row label > Hide to hide the subtotal rows. I used the group tool in the data tab of the ribbon so I could easily show and hide the lines to write this tutorial quickly.
Paste visible cells only
The problem with a regular copy and paste is that Excel also pastes into hidden cells, so I have to select visible cells first. I can do this with Go To Special:
Copy only visible cells
Copying cells in a filtered table will copy only visible cells by default, but if you have hidden (instead of filtered) rows or columns, Excel will also copy the hidden ones. We can use the same technique to copy only visible cells:
Final note
I hope you like the guide How to copy and paste only visible cells in Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.
