May 22 2022 04:49 AM
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 so being able to hard copy and paste to filtered rows is a must for me. Has anyone else encountered the same issue? The old trick of Ctrl G to evoke Special - visible cells only doesn't work either for hard copying to filtered rows!
May 22 2022 05:44 AM
Doesn't it work with Ctrl + C (copy) and Ctrl + V (paste)?
If you pre-insert the data in table and then filter?
I would recommend you, with permission, to add information about the Excel version, operating system and storage medium, it would help a lot to offer a more accurate solution.
A photo or a file (without sensitive data) would also help.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
May 22 2022 06:09 AM
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.
May 23 2022 01:16 AM
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?
May 24 2022 05:04 AM
May 24 2022 05:14 AM
May 24 2022 06:13 AM
May 24 2022 07:53 AM