Documentation / User FAQ / Calc / Previous-Next
When using Calc filters, selections that span a range of cells include filtered and hidden rows. Deleting a range of rows with a filter enabled will delete all rows in that range, whether they are visible or hidden, not just the visible rows. To select multiple rows individually, select the first row, then use Ctrl+click to select each additional row.
Documentation / User FAQ / Calc / Previous-Next