paste data over hidden cells that are filtered

D

derwood

i want to paste data to a filtered sheet that has rows hidden and for it to
ignore the hidden rows . i have excel 2007. please advise the simplest way
 
D

Dave Peterson

I find the easiest thing is to try to sort my data first so that I can have the
range to be pasted in one contiguous range. Then paste into that range.
 

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

Drop down list control value in vba 2
Cell data entering slow! 0
hidden rows, column copy-paste 0
Disabling copy/paste hidden cells 2
Copy addition formula of non-consecutive horizontal cells 2
Hide columns based on row values 2
hidden rows reappearing when using filter 2
Merging from an Excel file with graphics 1

Top