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?

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

It worked! Thanks a lot!

"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

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

Did that actually paste into the visible cells (and leave the hidden cells
alone) for you?

Arun wrote:

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


--

Dave Peterson

Sure did. Did it work for you?

PS: Of the hundred or so posts I've seen from you, that's the first time I
think I've seen you ASK a question on this site. Thanks for all your
contributions.

"Dave Peterson" wrote:

Did that actually paste into the visible cells (and leave the hidden cells
alone) for you?

Arun wrote:

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


--

Dave Peterson

I was surprised that it worked for you.

I tested using xl2003.

I put 1,2,1,2,1,2,1,2,1,2,... in A1:A20 of sheet1
I put a,b,c,d,e,f,... in A1:A14 of sheet2

I copied A1:A14 of sheet2.
I filtered to show the 2's in sheet1
I selected that filtered range and did the Edit|goto|special|visible cells
and then (with A2 the active cell in the selection), I did edit|paste

And when I showed all the data, it wasn't just the visible cells that got pasted
over.




Arun wrote:

Sure did. Did it work for you?

PS: Of the hundred or so posts I've seen from you, that's the first time I
think I've seen you ASK a question on this site. Thanks for all your
contributions.

"Dave Peterson" wrote:

Did that actually paste into the visible cells (and leave the hidden cells
alone) for you?

Arun wrote:

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


--

Dave Peterson


--

Dave Peterson