Do not paste in hidden cells
Maybe you could sort your range so the visible cells are together. Then paste
over those visible rows. Then sort the data back the way you want???
GIORGOS wrote:
I have a spreadsheet with 30 rows I hide 20 that are not in order and I want
to copy and paste data from another spreadsheet only in the visible cells.
But when I copy and paste excel paste from the cell I select and continues
pasting also at the hidden cells so I loose the order. Is there a way to
avoid pasting data in the hidden cells?
--
Dave Peterson
|