Ask Your Question

select and Delete many rows with shortcut

asked 2017-09-09 18:15:07 +0200

dimzev gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-09 20:18:30 +0200

librebel gravatar image

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.


edit flag offensive delete link more


Thank you my friend!!! it works

dimzev gravatar imagedimzev ( 2017-09-10 16:50:35 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-09 18:15:07 +0200

Seen: 1,049 times

Last updated: Sep 09 '17