Forum Discussion
Pasting info into visible cells
Hi. I am trying to paste data into visible cells only. I know there is a way to do this, but I cannot figure it out. Please help.
If you want to copy a single cell and paste it into the visible cells of a range:
- Select an copy the source cell.
- Select the target range.
- Press Alt+; to select the visible cells.
- Press Ctrl+V to paste.
It is not possible to paste a contiguous multi-cell range into visible cells only.