Forum Discussion

Vivian310's avatar
Vivian310
Copper Contributor
May 22, 2022

copy and paste to filtered rows

Hi I thought excel used to allow me to hard copy and paste visible cells to filtered rows but it seemed this functionality has lost possibly with the new Windows update? I need to work on elimination...
Excel
Sekoleyte's avatar
Sekoleyte
Iron Contributor
May 22, 2022

Vivian310 

 

Hi there.

 

You can use CTRL + R to copy cells right and CTRL+D to copy cells down. If you have a data that you have a problem, you can share an example for detalied solution.

  • Vivian310's avatar
    Vivian310
    Copper Contributor
    May 23, 2022

    Sekoleyte 

     

    Thank you. 

     

    Row 3 is filtered out. I wanted to hard copy A2:B4 (with A3:B3 filtered out) to visible cells in C2:D4, but I could only copy A2:B2 to C2:D2, and I have to copy separately A4:B4 to C4:D4.

     

    I thought I was able to hard copy and paste to visible cells without the above issue. Maybe I was wrong? 

     

     

    • Sekoleyte's avatar
      Sekoleyte
      Iron Contributor
      May 24, 2022
      Hi Vivian310
      While you choose only A2 and A4 (Yellow and Red) When you want to copy it to C2 and C4, it doesn't work. It's normal. Instead, it pastes them in C2 and C3. Appy Following steps that shared below.

      Choose A2:A4 and choose C2:C4 in the filtered range. Then press CTRL+R
      It will work if A2:A4 are constant instead of formula.
      • Vivian310's avatar
        Vivian310
        Copper Contributor
        May 24, 2022
        Sekoleyte
        Thank you. I thought excel allowed me to hard copy and paste to the same filtered rows but apparently it doesn't. It would be a good feature though. If copy can be applied to the visible cells only, why paste can't be applied to the visible cells only by default too.

Resources