![]() It might be in the beginning, middle or end of the keyword field. In my case, I didn’t wanted to filter by a specific value but by all values in the column that are related to the words “press release”. Excel will give you some options including all the values in the in the column you selected. Step 3 – Select the column you want to filter by and then click on Text FiltersĬlick on the arrow next to the column that you want to filter. 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.
0 Comments
Leave a Reply. |