Pasting info into visible cells

Occasional Visitor

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


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.