Question: how to copy and paste data in excel with hidden rows?
Answer: Select the cells that you want to copy For more information, see Select cells, ranges, rows, or columns on a worksheet. ...  Click Home > Find & Select, and pick Go To Special. Click Visible cells only > OK. Click Copy (or press Ctrl+C).