Ask Your Question

Printing all found columns on spreadsheet when using "Find All" [closed]

asked 2014-07-16 05:07:06 +0100

mpkettle gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-29 21:48:20.493848

1 Answer

Sort by » oldest newest most voted

answered 2014-07-17 01:32:42 +0100

m.a.riosv gravatar image

updated 2014-07-17 10:15:35 +0100

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.

edit flag offensive delete link more


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.

mpkettle gravatar imagempkettle ( 2014-07-17 02:53:35 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2014-07-17 10:13:17 +0100 )edit

Question Tools

1 follower


Asked: 2014-07-16 05:07:06 +0100

Seen: 75 times

Last updated: Jul 17 '14