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 :
Excel Skill Corner
Kerala, India.