Pasting into visible cells only

  • Thread starter Thread starter TV Man
  • Start date Start date
T

TV Man

I have two worksheets that are set up to custom view with
a sort function; i.e. it hides lines. I know how to copy
visible lines to a fully open worksheet. If the worksheet
I want to copy to is also sorted to have the same number
of visible lines is there a way to copy just into those
visible lines? I get an error box saying " cannot paste in
to multiple selections".
 
Excel will only paste into a contiguous range, so you can't copy visible
cells only, and paste into visible cells only.
 
Back
Top