SOLVED

Differences between copy/paste and dragging fill handle?

Copper Contributor

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 ?

1 Reply
best response confirmed by Joseph_S1525 (Copper Contributor)
Solution
For me the fill handle works the same as copy paste on a filtered range: hidden rows are excluded from both the paste and the fill. But I only did a small test.
1 best response

Accepted Solutions
best response confirmed by Joseph_S1525 (Copper Contributor)
Solution
For me the fill handle works the same as copy paste on a filtered range: hidden rows are excluded from both the paste and the fill. But I only did a small test.

View solution in original post