Forum Discussion
How to not overwrite cells in filtered table using copy and paste values
Hi, I have search for an answer to this question without satisfactory results. I hope someone here at the forum can help me out. The problem is that sometimes when I copy and past a value fr...
Hello, Thanks for your reply.
MicrosoftS Excel Microsoft 365 MSO (Version 2209 Build 16.0.15629.20200) 64-bit
Windows 10 Pro, Version 21H2, OS-version 19044.2130
I also reproduced it now in Excel for the web and was suprised to see that as you say, only the visable cells gets "ok" copied to them. Very strange.
MicrosoftS Excel Microsoft 365 MSO (Version 2209 Build 16.0.15629.20200) 64-bit
Windows 10 Pro, Version 21H2, OS-version 19044.2130
I also reproduced it now in Excel for the web and was suprised to see that as you say, only the visable cells gets "ok" copied to them. Very strange.
You may wish to review how this has been discussed elsewhere , and if you page + scroll to the responses by member Cangkir, how to resolve it with a procedure/macro.
- Thanks but I tried the solution and it did not work for me. Also, even if it did, it seems cumbersome to use a macro as a workaround for something that should be very simple and built in from scratch in Excel.