Copy & paste special under a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why sometimes paste special under a filter only paste to the filtered rows,
but sometimes are pasted to all the unfiltered rows?
 
I bet it only ever pastes to the contiguous cells. But maybe you got lucky in
that all the visible cells were contiguous.
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter, Copy and Paste 2
Copy and pasting values of filtered rows 1
How do I Copy and Paste onto Same Rows after filtering out rows. 2
Copy and Paste Format in filtered rows 6
Filter Sort Columns in a table. 3
How do I paste data into filtered list in Excel? 3
Paste Special 4
Filter-Copy-Paste Problem 3

Back
Top