pressing the Alt+; before doing the copy process will just select the visible cells alone. So it copy any hidden (row) cells when applying the copy process.