Forum Discussion
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...
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?
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.
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.
- 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.