Copy & paste special under a filter

H

Holly

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

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

Holly

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

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