How to copy some rows, but don't copy the hide row in some rows?

T

Thanh Cao

I'd like to copy "some rows" in Excel sheet, but I don't want to copy the
hide row in the "some rows".
Please hope me to solve this.
Thank you.
Thanh Cao
 
D

DJH6064

You can use the Go To Special command. After you hide your rows, select the
Find & Select button, then select Go To Special, then select the Visible
Cells Only option. This will only select the cells you highlight and then you
can copy only thoses cells. This will not copy any hiden cells, rows or
columns.
 
Top