Hidden columns copy & paste

[maheshmaxi]

Hi,

I am using excel 2007. I have many columns which are hidden in sheet1, now i want copy and paste visible columns only to sheet2. but after i pastes including hidden column in sheet2. Can anyone help me to sort this out?

 

[maheshmaxi]

I face same issue while copy and paste rows.

 

[VoG]

Select the range, press F5, click Special, tick Visible Cells Only then click OK. Then copy and paste.

 

[maheshmaxi]

Thanks Peter, It works fine.