How to sort through keywords efficiently?

JimHalpert · May 18, 2019

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 · Jun 30, 2019

humble bump?

Houdinii · Jun 30, 2019

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 · Jun 30, 2019

Houdinii said:
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.

Code:

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 · Sep 30, 2020

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 · Sep 30, 2020

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

How to sort through keywords efficiently?

JimHalpert

Supreme Member

JimHalpert

Supreme Member

Houdinii

Regular Member

JimHalpert

Supreme Member

snowshine

Junior Member

kptpiotr

Junior Member

Main Menu

Marketplace

Making Money

BlackHat World