Copy and Paste visible cells only

[lauren18]

Hi All,

I'm trying to copy and paste visible cells only.

for instance;

I have columns A to Z
but I columns C to H hidden

When I use Alt+; or Find & Select>Go To Special>Visible Cells Only it selects only the visible cells. I can see the perforated line separating the columns.

However when I paste into a new, blank document with no hidden columns, ALL of the data (columns A - Z) are pasted.

I'm so frustrated I'm pulling my hair out. Help!!

 

[Akuini]

The method ‘Find & Select>Go To Special>Visible Cells Only’ actually works for me, well, most of the time. But I read somewhere sometimes it works and sometimes not, don’t know why.
And just to be sure you need to press Ctrl+C after (not before) method ‘Find & Select>Go To Special>Visible Cells Only’
So the sequence is:
Select the cells > Find & Select>Go To Special>Visible Cells Only > ok > Ctrl+C.
But if the method still not working, I have a macro that can do that, and you can assign the macro to an icon in the toolbar so it will be simple to use it.
Let me know if you interested using the macro

 

[anglais428]

That should work. Just to be clear

Highlight the column range - CTRL G - Special - visible cells only - CTRL C - on new sheet CTRL V

It works for me.

 

[KC Cat]

lauren18, Akuini, and anglais428,

So, I have experienced the same thing with it working some of the time, and not some of the time. In my case, I have determined why this is.

If I copy visible cells from a workbook in one instance of Excel, then try to paste in another workbook that is open in a second instance of Excel, it does not work. And this is unfortunate, as I like to leverage the fact that I have multiple monitors.

On the other hand, it works if copying and pasting from either a) one sheet to another within the same workbook, or b) from one workbook to another within the same instance of Excel.

Conclusion: If anyone reading this knows how to make it work across multiple instances of Excel, please reply with the solution!!

Have a great day!

 

[KC Cat]

FYI - I am working in Excel 2010 on a Windows 7 platform. A coworker using Excel 2013 on a Windows 8 platform does not have any issues. This is because Excel 2013 inherently allows individual workbooks in the same instance to be drug to different monitors.