Forum Discussion
How to not overwrite cells in filtered table using copy and paste values
Victor107200Hello Victor, I have tried to reproduce your scenario. In both cases, only the visible cells were described with oK. I have tested under Excel for the Web. Which operating system and which Excel version are you working with? That would certainly be interesting for other testers.
dscheikey This is very true. If you have a ton of lines, Excel will overwrite invisible cells on a CTRl + P. It happens to me all the time. It never did it in the past, but in the last few years, it has happened daily. I have no idea why, either! I no longer trust excel... Large files, Excel is crap anymore.
- 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.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.
Do I do anything differently from you? See attached video!
Exel for the web: Build 16.0.15811.35904
Yes and no... When I do it as you do in the video I get the same result. But what I am trying to do is to copy and past values (or formulas, or formatting etc.). Please see my video and you will understand.
Thanks for taking the time to do a video. Appreciate it!
