Copy & paste special under a filter
 

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

Copy & paste special under a filter
 

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

Holly wrote:

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

--

Dave Peterson

Copy & paste special under a filter
 

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

"Dave Peterson" wrote:

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

Holly wrote:

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

--

Dave Peterson

Copy & paste special under a filter
 

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



Holly wrote:

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

"Dave Peterson" wrote:

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

Holly wrote:

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

--

Dave Peterson


--

Dave Peterson