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?

Comments

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)