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"