Forum Discussion

MsQ1972's avatar
MsQ1972
Copper Contributor
May 26, 2021

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.

1 Reply

  • MsQ1972 

    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.

Resources