How to Copy Visible Cells Only in Excel

by

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:

Worked Example:   Delete Blank Rows at Once in Excel

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.

Worked Example:   Advanced Find Features in Excel

3. Click Go To Special.

4. Click Visible cells only and click OK.

Worked Example:   Find, Select, Replace and Go To Special in Excel

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:

Leave a Reply

Your email address will not be published.