Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.

Any chance you can sort your data so that the visible rows would be contiguous?
Then your paste would work ok.



Tim Miser wrote:

Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.

--

Dave Peterson

I could but I am trying to avoid the sort function because it is a permanent
change to the order of goods. Yes, I could number the rows before sorting
and than re-sort back to the original order but I am hoping to avoid all of
those steps for a simple paste to visible cells.


"Dave Peterson" wrote:

Any chance you can sort your data so that the visible rows would be contiguous?
Then your paste would work ok.



Tim Miser wrote:

Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.

--

Dave Peterson

There's nothing like this built into excel.

Tim Miser wrote:

I could but I am trying to avoid the sort function because it is a permanent
change to the order of goods. Yes, I could number the rows before sorting
and than re-sort back to the original order but I am hoping to avoid all of
those steps for a simple paste to visible cells.

"Dave Peterson" wrote:

Any chance you can sort your data so that the visible rows would be contiguous?
Then your paste would work ok.



Tim Miser wrote:

Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.

--

Dave Peterson


--

Dave Peterson

I was worried that would be true. Thanks Dave.


"Dave Peterson" wrote:

There's nothing like this built into excel.

Tim Miser wrote:

I could but I am trying to avoid the sort function because it is a permanent
change to the order of goods. Yes, I could number the rows before sorting
and than re-sort back to the original order but I am hoping to avoid all of
those steps for a simple paste to visible cells.

"Dave Peterson" wrote:

Any chance you can sort your data so that the visible rows would be contiguous?
Then your paste would work ok.



Tim Miser wrote:

Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.

--

Dave Peterson


--

Dave Peterson

Tim,

You aren't the first to request that feature. Either no-one on the Excel
team has gotten around to adding it to the Paste Special options, or not
enough people want it, or it was decided such a thing is too dangerous.
After all, what if someone manually collapsed rows to apparent
invisibility, but Excel registered them as having non-zero height? One
could inadvertently overwrite data.

- David Hilberg

Tim Miser wrote:
I was worried that would be true. Thanks Dave.


"Dave Peterson" wrote:

There's nothing like this built into excel.

Tim Miser wrote:
I could but I am trying to avoid the sort function because it is a permanent
change to the order of goods. Yes, I could number the rows before sorting
and than re-sort back to the original order but I am hoping to avoid all of
those steps for a simple paste to visible cells.

"Dave Peterson" wrote:

Any chance you can sort your data so that the visible rows would be contiguous?
Then your paste would work ok.



Tim Miser wrote:
Hello, I have a filtered spreadsheet that I can copy visible cells using the
edit/goto/special/visible cells function but I want to paste the data in a
similar spreadsheet that is filtered the same way.

Is there a way to paste only in the visible cells? Right now if I paste,
the data will paste into both visible and hidden/unfiltered cells.
--

Dave Peterson

--

Dave Peterson