
Copy Visible Cells Only
If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.
By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only the summary data from an outlined worksheet.
Here's a convenient Excel tip that I hope you can use!
By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only.
In this example, row 2 is hidden.
When you copy/paste this range, this is the result:
To copy visible cells only, execute the following easy steps.
1. Select the range A1:A4.
2. On the Home tab, in the Editing group, click Find & Select.
3. Click Go To Special.
4. Click Visible cells only and click OK.
Excel selects the visible cells.
5. Press Ctrl + c to copy the range.
6. Select cell A6 and press Ctrl + v to paste the range.
Result: