One of the features of Excel is the ability to hide cells. However, if you copy a range that contains hidden cells and paste the selection elsewhere, you get all the rows including the hidden ones. This short tutorial will show you how to copy just the visible cells.

Below is a simple worksheet with 2 hidden rows…

1

If you select rows 1 – 7, issue the Copy command and then Paste the selection elsewhere, you get all the rows including the hidden ones…

2

In order to copy a range that includes hidden cells, but exclude the hidden cells when pasting, perform the following steps…

Select the range to be copied

From the Home tab, select the Find & Select button and select Go To Special from the menu

3

The Go To Special dialog box is displayed…

4

Select Visible cells only

Click OK

Issue the Copy command (Ctrl+C or from the Home tab, select the Copy button). Excel marks the cells to be copied with multiple selection marquees…

5

Position the cursor where you want to copy the block to and Paste (Ctrl+Vor from the Home tab, select the Paste button)

6