Step 2 – Click on Home tab, select Sort and Filter and then Filter
However Google delivered up hundreds of keywords related to press releases that I was not interested in. In this case I was looking at keywords related to a specific type of content marketing. (Note: the screenshots and instructions below are for Excel 2010) Step 1 – Determine what text or values you want to delete (or keep). So how do I cut a large spreadsheet down to manageable size, keeping only the rows I want or deleting rows that I definitely don’t want? I don’t want to go through each row one by one, though I can tell just by looking at the spreadsheet some types of key words are not what I want. I use Google’s keyword planner all the time but Google will dump everything but the kitchen sink into the relevant key words and I wind up with spreadsheets that are hundreds of rows long.