When i use a filter take for answer many rows (3000)
i want select this rows and delete them .
the only way i know is drag mouse to the end row
Have any other way with shortcuts to select this rows?
Hello @dimsev,
please try any of the following shortcuts:
Shift+Page Down Selects cells from the current cell down to one page in the current column or extends the existing selection one page down.
Ctrl+Down Arrow Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty, the cursor moves down to the next row that contains data.
Ctrl+Shift+Arrow Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected.
Ctrl+ * where (*) is the multiplication sign on the numeric key pad. Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns.
Then you can just press the DEL button to delete the selection.
Thank you my friend!!!
it works