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...
Victor107200
I am familiar with this bug. I am a consultant and both me and my clients frequently work in excel.
On my end it seems to happen in regular (non table) cells as well when many users filter rows and use the "only show my own filters" option.
I'm wondering why I keep overwriting data in our shared file where everyone uses "only show my own". Thank you for the information.
- How do we fix it? It has bothered me for years now. I no longer trust excel because of it.
