Problem: How to select only visible cells. (Some cells are hidden)

How to hide cells

Solution:

1. Select the cells you want to copy
2. Click "Find and select"
3. Click "Go to special..."

   

4. Click "Visible cells only"
5. Click ok!
6. Hold Ctrl + C to copy only visible cells
7. Paste (Ctrl + V) wherever you want

How to hide a row:

1. Select a row
2. Right click on a row number
3. Click "Hide"

Related posts:

Vlookup visible data in a table and return multiple values in excel

Populate a list box with visible unique values from an excel table (vba)

Excel vba: Select cell A1 on all sheets before you close a workbook

Select a cell in a table and the chart updates automatically (vba)

Select 6 unique and random numbers from 1 to 49 (Lottery) in excel