Pasting on Filtered Data Sheets without pasting onto hidden cells

G

Guest

How do you paste onto filtered data and prevent hidden cells from receiveing
the data when you paste.
 
D

Dave Peterson

Can you sort the unfiltered data by some key that groups the rows you want
together?

Then you could paste and sort back to the original order.

There's nothing built into excel that does what you ask.
 

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

Paste 3
drag data vertically over hidden cells.. ignore hidden cells 1
Copy and paste area not same in filtered mode . 8
Copy and Paste Format in filtered rows 6
Filter, Cut and Paste Problem 3
To paste copied data in filtered/visible cells only 1
pasting data on hidden cells 2
Filter-Copy-Paste Problem 3

Top