Translate

Tuesday, February 14, 2017

Copy Data on visible cells only (Skip hidden Cells)


Objective
Paste data on visible cells only, hidden rows/cells should not be replaced during Copy / Paste process.





Let’s do it


1) Hide the Rows where data should not be copied
2) Copy the data (Ctrl + C)
3) Select Target Cells
4) Press ( Alt + ; i.e Alt + Semicolon) , Shortcut key to select visible Cells only
5) Paste Data ( Ctrl + V)
6) Unhide Rows

No comments:

Post a Comment