Paste visible cells?

[Guest]

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]

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

 

[Guest]

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]

There's nothing like this built into excel.

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.

 

[Guest]

I was worried that would be true. Thanks Dave.

There's nothing like this built into excel.

 

[David Hilberg]

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

I was worried that would be true. Thanks Dave.

There's nothing like this built into excel.

 

[Brian Maurer]

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.

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

I was worried that would be true. Thanks Dave.

 

[Dave Peterson]

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.

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.

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

 

[EZHOU]

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...

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.