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