Do not paste in hidden cells
Funny. Mr. Peterson had a better answer to this problem back on a post dated
7/06/06, just in reverse (how do you COPY a selection while ignoring hidden
rows). Try this:
Select your copy range
edit|copy
Select your filtered target range
edit|goto special|Visible cells only
edit|paste
"Dave Peterson" wrote:
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
|