Paste visible cells?
 

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.

Paste visible 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

Paste visible cells?
 

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

Paste visible cells?
 

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

Paste visible cells?
 

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

Paste visible cells?
 

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

Paste visible cells?
 

Excel 2000-2003 did permit this and it is very useful and saves time. To be
frank, I find Excel 2007 more of a step back than forward and far more
cumbersome than it should be. The same comment applies to copying only
visible cells. Why would I want to go the extra step to copy only visible
cells?
I disagree that "such a thing is too dangerous". Think about it. I filter my
data so I can work only with what I have.


"David Hilberg" wrote:

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

Paste visible cells?
 

None of the earlier versions of excel that I've used has allowed this pasting
into only the visible cells: xl95, xl97, xl2k, xl2002, xl2003.

I think you're misremembering.

Brian Maurer wrote:

Excel 2000-2003 did permit this and it is very useful and saves time. To be
frank, I find Excel 2007 more of a step back than forward and far more
cumbersome than it should be. The same comment applies to copying only
visible cells. Why would I want to go the extra step to copy only visible
cells?
I disagree that "such a thing is too dangerous". Think about it. I filter my
data so I can work only with what I have.

"David Hilberg" wrote:

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



--

Dave Peterson

Paste visible cells?
 

Tim & Brian -- I am also looking for this functionality. And since I have
been using that functionality for the past 2 years, somehow I doubt that
we're all "misremembering."

If a developer reads this, PLEASE ADD THIS FUNCTIONALITY. If I'm filtering
my data to cut it in a certain way, it only makes sense that what I paste
should apply only to the data I'm looking at...

"Dave Peterson" wrote:

None of the earlier versions of excel that I've used has allowed this pasting
into only the visible cells: xl95, xl97, xl2k, xl2002, xl2003.

I think you're misremembering.

Brian Maurer wrote:

Excel 2000-2003 did permit this and it is very useful and saves time. To be
frank, I find Excel 2007 more of a step back than forward and far more
cumbersome than it should be. The same comment applies to copying only
visible cells. Why would I want to go the extra step to copy only visible
cells?
I disagree that "such a thing is too dangerous". Think about it. I filter my
data so I can work only with what I have.

"David Hilberg" wrote:

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



--

Dave Peterson