Forum Discussion
Values appearing/changing location
If you copy data from a range that has been filtered, then paste it elsewhere, only the data from the visible rows will be pasted.
But if you copy data and paste it to a range that has been filtered, Excel will paste to all rows, not just the visible ones. So if you don't notice that the target range is filtered, you'll get unexpected/undesired results.
HansVogelaar Thanks for the reply.
I do not think this applies here. The following is the process, and the error we observe. We read a email regarding values A,D,G in Col1. Then, we filter to see these three rows and enter data into Col2 and Col3. Later, we see the values in three other rows, but not A,D,G. If it was due to the error you described, I assume we would see the values in many other cells, including the correct ones A,D,G?
- HansVogelaarNov 29, 2023MVP
That looks like a differet problem. I've never seen that happen...