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?