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
|