Oct 11 2021 08:41 AM - edited Oct 11 2021 08:42 AM
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 ?
Oct 14 2021 06:06 AM
SolutionOct 14 2021 06:06 AM
Solution