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...
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.