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

Data entry on filtered rows. 4
Problem with Pasting into Filtered Fields 2
Paste visible cells? 8
Disabling copy/paste hidden cells 4
hidden rows problem 7
Excel formulas - comparing adjacent cells 5
drag data vertically over hidden cells.. ignore hidden cells 1
Excel 2007 Problem with Filter 2

Top