Printing all found columns on spreadsheet when using "Find All"

[mpkettle]

Is there an easier way ?

I enter a word in the find box, use ‘Find All’ and all examples are shown in a drop down with their cell listings. Data in other columns is not shown.

I need a print-out of all the data.

At present I hand copy the cell numbers, close the drop-down, highlight these on the spreadsheet, and ‘copy’.
When I use ‘paste’ to a free area on the spreadsheet, the found items including the data in all columns are shown, ready for printing.

Any suggestions would be appreciated that would save me time. Thanks - Maurice.

[mariosv]

I don’t know if it is exactly what you want, but.

Hide all columns in the sheet or those in the range to print.
Do the search as you describe.
Show the columns of encountered cells with Menu/Format/Columns/Shows.

edited 2014-07-17

Filter rows it’s more simple, using the filter tools: Menu/Data/Filter/Autofilter.

[mpkettle]

Thanks for the suggestion - not quite what I need.
I have about 4000 rows of data. Ideally I would like to be able to use “Find all” to highlight the found rows with all the data shown (as originally typed in). I could then copy and paste for printing.
The cell numbers are shown in the drop-down window but I haven’t come up with a way of easily using this information to highlight the required rows. The only way at present is to scroll through the 4000 lines and use Mac Cmd key as I highlight the rows listed in the drop-down window. - Maurice.

[mariosv]

Sorry @mpkettle, but I think your comment was about columns.