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