Problem: How to select only visible cells. (Some cells are hidden)
- Select the cells you want to copy
- Click "Find and select"
- Click "Go to special..."
- Click "Visible cells only"
- Click ok!
- Hold Ctrl + C to copy only visible cells
- Paste (Ctrl + V) wherever you want
- Select a row
- Right click on a row number
- Click "Hide"