Friday, August 6, 2010

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...!

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?

No comments:

Post a Comment