Copy visible cells...
Have you ever tried copying a list where there are multiple hidden rows...? Whats the result??
You will see all the values irrespective of the hidden or visible cells...!
- Copy the given cell range
- Press "Alt + C"
- Press "Ctrl + C"
- Paste at the desired location (Ctrl + V)
Now see the difference...!
Simple... isnt it?