Excel copy, missing cells when paste - Help!

**strutzas** · 03-02-2011, 08:59 PM

Usually, I can solve my Excel problems with a few searches, but this has taken me for a loop. When I copy a set of consecutive column cells, they are split with dotted lines (see attached image) and do not copy over properly when I paste. I am missing cells when I paste to the same or another spreadsheet.

One thing to mention is that this column was filtered to remove duplicate cells. I think this is where the problem lies, but cannot understand what to do to fix the problem.

I am having this problem with Excel 2007 (win xp) and Excel 2008 (Mac OS X 10.6.6).

I have literally wasted a couple hours searching for solutions with no avail, any help is greatly appreciated as I am on a deadline.

Thank you

**MarvinP** · 03-02-2011, 09:23 PM

Hi strutzas and welcome to the forum.

It looks like you have hidden rows in your selected range.

Try to unhide rows before copy and paste.

**strutzas** · 03-02-2011, 09:57 PM

Hey thanks, Marvin. Your solution worked. I did not notice the missing # cells.

Here is another helpful post http://www.asap-utilities.com/blog/i...07-workaround/

**MarvinP** · 03-02-2011, 10:06 PM

Hey - I like the Select Visible Cells Only. I don't use that (ever). Just another function hiding in Excel that I don't know about.

Thanks for the hint.

**areht** · 08-31-2015, 10:38 AM

How can I unhide rows?

**FDibbins** · 09-02-2015, 05:43 PM

areht, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.