paste data over hidden cells that are filtered

  • Thread starter Thread starter derwood
  • Start date Start date
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
 
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.
 
Back
Top