Copy visible cells...
![Image](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhtY3qY4ihGxtFHxeKScZ_3lln6gHAx33IFRdhXOGBxUlNF5tYHM_M_VsfwL7SzGeWTWCU27KWjVnBv8kRC1q8Pgbf3ozL4P3NndrIA_NAsXgn2yLvt3qAzZTSre-iRFKU4DOzU2c6XpBV/s320/select.gif)
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...! Shortcut: 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?