Copy data without hidden rows

[jimboryan]

Is there a way to copy and paste a sheet from one spreadsheet to another without getting the rows that have been hidden? I have a database with about 800 rows and another 150 or 200 scattered through it that are currently hidden. For what I need right now I don't want any of that hidden data. Do I have to manually delete it or is there a way to ignore it (I thought of paste special but I can't find one that works).

Thanks,

[AlKey]

Hi jimboryan,

1. Select rows you want to copy
2. Press F5, click on Special and select Visible cells only, press OK
3. Copy selected cells and paste them to new location.

[jimboryan]

Thank you! Worked perfectly!!