How do I select of data selected in find dialog in Calc?

I ctrl+f for mt7621 in a 2500 row spreadsheet, then I ctrl+click the row to select only rows contain mt7621, but I get about 2100 row and I accidentally unclick everything.

Is there a way to select all rows that contain cells selected in the find dialog?

If selected cells are not selected in one movement (click and drag, or Shift+Up/Down arrow), Select Row will select only the row of the last cell selected. So, if cells selected are A1;A2 (note the semicolon) only row 2 will be selected; and if A1:A2 (note the colon) both rows will be selected.

Please, edit your question (below your question, three dots icon, then pencil icon), and add:

  • mt7621 is the only text in the cells?
  • All occurrences are in the same column?
  • What do you want to do to those rows?
  • The data can be sorted?
  • Can you use an auxiliary column with a formula?
  • LibreOffice version and operating system.

Don’t use Suggest a solution to write something that is not a solution. Thanks.

1 Like

I really do not see how my question can be more clear, and answering those questions will not help anyone solve the problem. Therefor, the solution is to ask on a different forum. Thanks.