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

How to hide cells


  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"