Do not copy hidden columns

[BradleyS]

I have a spreadsheet of data that has a few hidden columns.

However, if I copy and paste or even paste special it still copies the hidden columns and exposes them so they now show.

When I use an AutoFilter and copy data it never copies the hidden rows, which is great.
So is there a method I could use in the same way for my hidden columns, so that it only pastes what shows?

 

[njimack]

Press F5
Press 'Special'
Select 'Visible cells only'

 

[VoG]

Try this: select the data, press F5, click Special, tick Visible Cells Only and click OK. Then copy and paste.

 

[Ravinder Kumar]

Dear,

Press F5, Special Select Visible cells only. then copy & paste.

Ravinder

 

[BradleyS]

This forum is fantastic!

I would never of figured that out in a million years, thank you all.