You must have surely come across this problem atleast once while using Excel, trying to copy Only Visible (non hidden) cells, but the entire selection gets copied.

Let’s say you have data as below, in cells A1 to A6.



Then you hide rows 3 & 4, as below.

Now you want to copy and paste only this visible data (rows 1, 2, 5, 6), and not all 6 rows.

Steps: 

  1. Select the entire data.
  2. Under Home tab, click on Find & Select.
  3. Select Go to Special…
  4. Select Visible cells only, and click on Ok.
  5. Press Ctrl + C (copy to clipboard).
  6. Go to the place where you want to paste the data.
  7. Press Ctrl + V (paste).
Hurray! Its that simple!
 
Keep Excel-ling!