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.