How to copy and paste visible cells in Excel

  • Post author:
  • Post category:Uncategorized

When working on a worksheet, you might encounter a situation where some cells either do not appear or simply not visible. In such a situation, we have the option to select only visible cells. Note that by default, Excel will copy both visible and invisible cells.

Figure 1: Copy paste visible cells

In figure 1 above, we have row 2 invisible or hidden.

If we were to copy and paste the range in the above figure, we shall get result as shown in figure 2 below;

Figure 2: Copy paste a range of cells

With this procedure, you might have noticed that we have copy/pasted both hidden as well as visible cells.

But what if we want to copy and paste only visible cells? Well, we can select visible cells only in Excel 2010 and other versions by following a simple procedure as explained below;

Steps to copy only visible cells

In order to copy visible cells in Excel, follow the steps below;

Step 1: Select the range of visible cells you want to copy. In our example, the range is A1:A4

Step 2: Click Find & Select

To get the Find & Select tab, head to the Home tab, and under the Editing group, click on the Find & Select.

Figure 3: Choose Find & Select

Step 3: Clock Go To Special

In the drop-down menu that appear, click “Go To Special

Figure 4: Choose Go To Special

Step 4: Select Visible cells only

You will be presented with a window with various Go To Special options. Among the options is Visible cells only. Click on it and the click OK.

Figure 5: Click ok

Step 5: Copy the range

The next thing you have to do is to copy the visible range. To do this, simply press Ctrl + C.

Step 6: Paste the range

Now that we have copied the visible cells, we now have to paste them. Pasting visible cells is actually easy, all we need to do is select where we want to paste them then press Ctrl + V.

Figure 6: Pasting the visible cells