Copy & paste special under a filter

[Guest]

Why sometimes paste special under a filter only paste to the filtered rows,
but sometimes are pasted to all the unfiltered rows?

 

[Dave Peterson]

I bet it only ever pastes to the contiguous cells. But maybe you got lucky in
that all the visible cells were contiguous.

 

[Guest]

What do you mean by contiguous cells? Are the contiguous cells from the
filter or...?

 

[Dave Peterson]

Contiguous means touching.

So if you filtered and saw that rows 8-15 are visible and pasted 4 cells
starting in row 8, it would be pasted in 8, 9, 10, 11 (all visible).

If you filtered and saw rows 8, 10, 12, 14, ...
and copy|Pasted 4 rows starting in row 8, you'd still paste to rows 8, 9, 10, 11
(some visible and some not visible).