Hey all,

I've tried researching this on existing forum threads but haven't found a solution to my problem.

I have to go through sheets and remove rows that have unimportant information on it. these sheets often have over 10k rows and I need to one by one assess whether a row is important based on the information in a couple different columns. If they are unimportant they need to be removed from the sheet. Until this point I have been using the cursor to select them one by one and press f4 to repeat the delete action but it's not easy to click the small block at the start of each row while keeping an eye on the columns that have the relevant information. When I use arrow keys it jumps from the entire row to the first cell in the next row, which is obviously not what I want. I have found a macro somewhere that will highlight the entire row but it doesn't help me much since it still just has the first cell selected and just colours in the other cells of that row.

is there a way to have an entire row selected, and then use keyboard commands (like arrow keys combined with another key or something) to select the entire row below it?