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?


Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Excel Keyboard Shortcuts - Handy during day to day work

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)