Paste visible cells?

T

Tim Miser

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

Dave Peterson

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

Tim Miser

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

Dave Peterson

There's nothing like this built into excel.

Tim said:
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.
 
D

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

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


Dave Peterson said:
There's nothing like this built into excel.
 
B

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.


David Hilberg said:
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 said:
I was worried that would be true. Thanks Dave.
 
D

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.

Brian said:
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 said:
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
 
E

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

Dave Peterson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top