Pasting info into visible cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2387709%22%20slang%3D%22en-US%22%3EPasting%20info%20into%20visible%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2387709%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20am%20trying%20to%20paste%20data%20into%20visible%20cells%20only.%20I%20know%20there%20is%20a%20way%20to%20do%20this%2C%20but%20I%20cannot%20figure%20it%20out.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2387709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2388076%22%20slang%3D%22en-US%22%3ERe%3A%20Pasting%20info%20into%20visible%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1063825%22%20target%3D%22_blank%22%3E%40MsQ1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20copy%20a%20single%20cell%20and%20paste%20it%20into%20the%20visible%20cells%20of%20a%20range%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20an%20copy%20the%20source%20cell.%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20target%20range.%3C%2FLI%3E%0A%3CLI%3EPress%20Alt%2B%3B%20to%20select%20the%20visible%20cells.%3C%2FLI%3E%0A%3CLI%3EPress%20Ctrl%2BV%20to%20paste.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIt%20is%20not%20possible%20to%20paste%20a%20contiguous%20multi-cell%20range%20into%20visible%20cells%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@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.