This means that any data in hidden rows or columns is included when you copy a selection.
Chances are, that’s not what you want.
In this video we’ll show you how to work with visible cells only.
Here we have a list of real estate properties.
This is because Excel selects both visible and hidden cells by default.
To get around this problem, we need to tell Excel to select only visible cells.
First, make the selection normally.
In the Go To Special dialog, select Visible Cells Only.
Only data in cells that were visible will be copied.
Back in the original worksheet, we can verify the selection by unhiding the columns.
Now you’re free to see the moving dashed line around the cells that were copied.
Notice the cells that were hidden are not included.
As before, we’ll hide the columns and then make a normal selection.
This time, however, we’ll use Alt ; to change the selection to visible cells only.
Now we’ll copy.
When we paste, we get only the data from cells that were visible.
