How to copy only visible rows

[JK1234]

I have a spreadsheet that has hidden rows, I want to somehow either delete the unvisible rows or to be able to copy the visible rows to another sheet???

[deadlyduck]

To make hidden rows unhidden: click on the row numbers above and below the hidden row; right click and choose Unhide from the popup menu

To copy a row's contents to another sheet: right click on the row number, select Copy from the popup menu then go to your new sheet, right click choose Paste.

[JBeaucaire]

Highlight the data you want to copy.
Press F5 and click SPECIAL
Click on [x] Visible cells only
Click OK
Press CTRL-C to copy
Switch to other sheet and select target location, press ENTER

Only the visible data will copy over.

[JK1234]

Thank you!!!

Works

[deadlyduck]

Thanks from me, too, JBeaucaire- that's a useful dialog box I never knew existed!

[martindwilson]

its even easier if you stick the select visible cells icon on the tool bar!
customise/commands/edit scroll to bottom and drag the select visible cells button onto any toolbar

[deadlyduck]

Yep- that would have solved the particular problem outlined by the original poster. {Note to self: Explore toolbar customisation possibilities in more detail...}

I am delighted to have found out about the dialog box as it allows for many additional possibilities.