Blog

How to copy visible cells only

How to copy visible cells only



While working in the excel file we will face the problem while coping the data contains hidden rows and at the pasting the data it will give all the data including hidden rows.

Situation we faced


 

 

For solving this issue  we have two solution one is through Go To Special Option


 

 

And another method  is through Short Cut Alt+;



Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.