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