How to sort through keywords efficiently?

[JimHalpert]

Currently extract them to excel and go through one by one, highlighting those I think are good.

This is very inefficient. After you reach the bottom of a section and hit page down, the cursor drops right to the bottom of the screen, I then have to manual tap up many times to move up to the keyword where I left off and then move down again.

You may wonder: Why not just keep going down without hitting page down. Cause each time I do that, excel "skips" so it makes reading of the subsequent keyword slower.

Anyone has any productivity tips?

 

[JimHalpert]

humble bump?

 

[Houdinii]

I'm not sure why it skips, I usually use the mouse wheel. That won't move the box you're currently in. But usually I make any spreadsheet a table and insert a new column that I type an 'x' into or a different letter if I'm marking for something else, and then filter it at the top of the table. Quick and dirty but uses the least amount of keyboard movements for me.

EDIT: Here's a table link if you need it. I would add a column to mark which to save, and then make it into a table so you can quickly pull up the rows that have x's. Then you can copy and paste those into a new file if you wish. https://www.contextures.com/xlExcelTable01.html

 

[JimHalpert]

I'm not sure why it skips, I usually use the mouse wheel. That won't move the box you're currently in. But usually I make any spreadsheet a table and insert a new column that I type an 'x' into or a different letter if I'm marking for something else, and then filter it at the top of the table. Quick and dirty but uses the least amount of keyboard movements for me.

EDIT: Here's a table link if you need it. I would add a column to mark which to save, and then make it into a table so you can quickly pull up the rows that have x's. Then you can copy and paste those into a new file if you wish. https://www.contextures.com/xlExcelTable01.html

Thanks, that is helpful! Will look into it.

Not sure if it is useful to you but I have also managed to get a VBA script to insert "elevator cells" in excel so that I can quickly jump to different sections of the excel when sorting keywords.

Sub x()

Dim i As Long

With ActiveSheet
For i = 1 To .Cells(.Rows.Count, "A").End(xlUp).Row - 38 Step 38
    Cells(i, 7) = "Step"
Next i
End With

End Sub

 

[snowshine]

I like to have a check box next to the cell (text string) and if the box is checked (true) then a copies the data into a new sheet or column

 

[kptpiotr]

You can also try google sheets - maybe it is more convenient