Differences between copy/paste and dragging fill handle?

%3CLINGO-SUB%20id%3D%22lingo-sub-2834618%22%20slang%3D%22en-US%22%3EDifferences%20between%20copy%2Fpaste%20and%20dragging%20fill%20handle%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2834618%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20in%20a%20massive%20report%20with%20filters%20(NOT%20a%20table%2C%20just%20Data%20%26gt%3B%20filter%20range)%2C%20and%20have%20users%20that%20drag%20the%20fill%20handle%20down%20when%20pasting%20data.%20For%20example%2C%20if%20they%20type%20'done'%20and%20then%20drag%20fill%20handle%20down.%20Some%20others%20copy%20and%20select%20all%20the%20cells%20manually%20then%20paste%20it.%20But%20it%20appears%20%3CSTRONG%3Ethe%20fill%20handle%20can%20sometimes%20fill%20in%20hidden%20cells%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20what%20are%20the%20differences%20between%26nbsp%3Bcopy%2Fpaste%20and%20dragging%20fill%20handle%20when%20there's%20a%20filter%20applied%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2834618%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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
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.