Hello.
This may be a silly question, but it's a big mystery to me.
If in Excel I enable the filter on some column, will it hide the rows.
It copies all cells with a filtered value, sometimes only the filtered values are copied, and sometimes all, even the hidden ones.
E.g:
If I copy the cells highlighted in black, sometimes hidden rows 50 and 51 will also be pasted when pasting
What it depends on? whether it is copying or cutting out cells or whole rows?
This may be a silly question, but it's a big mystery to me.
If in Excel I enable the filter on some column, will it hide the rows.
It copies all cells with a filtered value, sometimes only the filtered values are copied, and sometimes all, even the hidden ones.
E.g:
If I copy the cells highlighted in black, sometimes hidden rows 50 and 51 will also be pasted when pasting
What it depends on? whether it is copying or cutting out cells or whole rows?
