I use tables. I use filters to display some row data only.
Excel appears to have inconsistent behaviour.
Sometimes if I copy and paste data, it only applies to the displayed cells. Sometimes it applies to both displayed and hidden cells.
Let's say I have a filtered table A1 to A6. The status of each cell:
A1 Header row, displayed
A2 displayed
A3 displayed
A4 hidden
A5 displayed
A6 displayed
I copied cell A2 by Ctrl+C. Highlighted A3 to A6 (bear in mind A4 is hidden). Pasted by Ctrl+V.
It is expected to paste only to A3, A5 and A6.
But in some cases (of course not in the above example), it will paste the data to the hidden cells too. I fail to spot the pattern.
Does anyone know how this will happen?
Is there any surefire way to copy and paste so it will NEVER paste to the hidden cells?
Thank you.
Bookmarks