Microsoft Excel 2007 with Example

5 Find & Select

5.4 Find & Select :Copy Visible Cells Only

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only.

In this example, we've unhidden row 2.

Copy Visible Cells Only Example

When you copy/paste this range, this is the result:

Hidden Cells Copied

To copy visible cells only, execute the following easy steps.

1. Select the range A1:A4.

2. On the Home tab, click Find & Select, Go To Special...

Click Go To Special

3. Click Visible cells only and click OK.

Visible cells only

Excel selects the visible cells.

4. Press Ctrl + c to copy the range.

5. Select cell A6 and press Ctrl + v to paste the range.


Copy Visible Cells Only Result