I'm working in a massive report with filters (NOT a table, just Data > filter range), and have users that drag the fill handle down when pasting data. For example, if they type 'done' and then drag fill handle down. Some others copy and select all the cells manually then paste it. But it appears the fill handle can sometimes fill in hidden cells?
So what are the differences between copy/paste and dragging fill handle when there's a filter applied ?