Greg Ichshenko

Calgary SEO expert and digital marketing specialist,
developing advertising strategies for businesses of all sizes

(403) 308-5949

greg@to-the-top.ca
1509 14 Ave SW, Calgary,
AB T3C 0W4

    Submit your request or question, and I will get back
    to you shortly

    How to Search for a Keyword in Excel

    There are five practical ways to search for a keyword in Excel, and the quickest is to press Ctrl+F, type the word and select Find All to list every cell that contains it. To see only the matching rows, turn on Data > Filter and use Text Filters > Contains. To flag every row with a formula, use =ISNUMBER(SEARCH("keyword",A2)), which returns TRUE or FALSE. In Excel for Microsoft 365, 2021 or 2024, =FILTER(A2:C500,ISNUMBER(SEARCH(F1,A2:A500)),"No match") turns cell F1 into a live search box. To add keywords to rows as tags, an XLOOKUP formula can read each row and assign a category from a keyword list.

    The rest of this guide walks through those five methods with a keyword research export as the example, because that is where a single sheet can easily run to thousands of rows. The same steps work on a customer list, a product catalogue or a Google Ads search terms report.

    Man pushing a speedometer needle into the orange zone beside Ctrl and F keys

    Find a keyword with Ctrl+F and Find All

    Press Ctrl+F, or go to Home > Editing > Find & Select > Find, and type the keyword in the Find what box. Find Next jumps to one cell at a time, while Find All lists every match in a panel at the bottom of the dialog, and selecting a result selects its cell. Microsoft notes that you can sort the Find All results by selecting a column heading, which is handy when a keyword turns up in several columns at once.

    Select Options to make the search more precise. Within lets you search the current sheet or the whole workbook, Match case makes the search case-sensitive, and Match entire cell contents finds only the cells that hold exactly what you typed. That last setting matters with keyword lists: a plain search for “seo” also finds “local seo” and “seoservices”, whereas a whole-cell search finds only the cell that reads “seo” and nothing else. Find also accepts wildcards, so plumb*calgary finds “plumber calgary” and “plumbing calgary” in one pass, and a tilde before a question mark (~?) finds a real question mark, which helps when you are hunting for question-style keywords.

    Man pressing an orange SEO card on a board of keyword cards labelled Ads, Local, Maps, Brand and Shop

    Show only the rows that contain the keyword

    Find tells you where a keyword is, but a filter hides everything else so that you can work with the matching rows. Select a cell in the data, choose Data > Filter, select the arrow in the keyword column’s header, then choose Text Filters > Contains and type the word. In the same dialog you can add a second condition and choose And (both must be true) or Or (either can be true), which covers searches such as “contains calgary” or “contains yyc”.

    Filters are additive across columns, so each new filter narrows the rows left by the previous one. With a keyword research export, that means you can filter the keyword column for “emergency” and then set Number Filters > Greater Than on the volume column to keep only the terms above a volume threshold you choose. Microsoft recommends not mixing text and numbers in one column, because Excel shows only one type of filter per column, and it picks whichever type occurs most. A volume column where many cells hold text such as “<10” or “n/a” can end up offering Text Filters instead of Number Filters until you clean it.

    A filter is also the right tool for the opposite job, removing junk terms from a list, and that has its own quirks, so there is a separate guide to filtering a keyword list by exclusion.

    Man posting an orange envelope into a mailbox

    Search many keywords at once with formulas

    Formulas earn their place when you need a permanent answer next to every row instead of a one-off search. The basic pattern is a helper column with =ISNUMBER(SEARCH("calgary",A2)), copied down. SEARCH returns the position where the text starts and a #VALUE! error when it is missing, so wrapping it in ISNUMBER turns the result into TRUE or FALSE, which you can then filter, count or sort. SEARCH is not case-sensitive and accepts the ? and * wildcards, while FIND is case-sensitive and does not accept wildcards, so use FIND only when “SEO” and “seo” must be treated differently.

    To count how many cells contain a keyword, =COUNTIF(A2:A5000,"*calgary*") works because the asterisks match any characters before and after the word. It counts cells, not mentions, so a cell that says “calgary seo calgary” counts once. Microsoft also warns that COUNTIF returns wrong results for strings longer than 255 characters, which rarely affects keywords but can affect long page titles or ad descriptions.

    To check several keywords at once, put them in an array: =SUMPRODUCT(--ISNUMBER(SEARCH({"calgary","yyc","airdrie"},A2)))>0 returns TRUE when any of the three appears in the cell. This is the quickest way to scan a search terms export from Google Ads for location words or for terms you never meant to pay for.

    Match whole words with REGEXTEST

    Partial matching is the main weakness of SEARCH and Find, because “seo” also matches “seoservices” and “ads” matches “headset”. Excel for Microsoft 365 now has REGEXTEST, which checks text against a regular expression and returns TRUE or FALSE. The formula =REGEXTEST(A2,"\bseo\b",1) matches “seo” only as a whole word, because \b marks a word boundary and the final 1 makes the match case-insensitive (REGEXTEST is case-sensitive by default). The function is listed for Excel for Microsoft 365 on Windows and Mac only, so if a workbook is shared with someone on Excel 2019 or 2021, those cells will not calculate for them.

    Build a keyword search box with FILTER

    The FILTER function returns every row that meets a condition and spills the result into the cells below. Type a keyword in F1 and put =FILTER(A2:C500,ISNUMBER(SEARCH(F1,A2:A500)),"No match") in F3, and the matching rows appear under it; change F1 and the list updates. Leave F1 empty and it shows every row, because an empty search matches everything. The third argument matters, because without it Excel returns a #CALC! error when nothing matches. FILTER is available in Excel for Microsoft 365, Excel 2021 and Excel 2024, but not in Excel 2019 or 2016, where the helper-column method above is the fallback.

    Method Best for Excel versions
    Ctrl+F, Find All A quick check of where a word appears All current versions
    Text Filters > Contains Working with only the matching rows All current versions
    ISNUMBER(SEARCH()) helper column A TRUE/FALSE flag you can filter and count All current versions
    REGEXTEST Whole-word or pattern matches Microsoft 365 only
    FILTER search box A live list that updates as you type Microsoft 365, 2021, 2024
    XLOOKUP tag column Assigning a category to every row Microsoft 365, 2021, 2024 (INDEX and MATCH for older versions)

    Man pointing at a column of search bars with the top one highlighted in orange

    How to add keywords in Excel

    “Adding keywords” in Excel usually means one of three things, and the method depends on which one you need.

    The most useful for keyword research is a tag column that reads each row and assigns a category automatically. Exceljet’s version of this formula, with a fallback value added, is =XLOOKUP(TRUE,ISNUMBER(SEARCH(keyword,A2)),category,"Unsorted"), where keyword and category are two columns on a lookup sheet. SEARCH checks the row against every keyword in the list, ISNUMBER turns the results into TRUE or FALSE, and XLOOKUP returns the category beside the first TRUE. Because XLOOKUP returns the first match it finds, the order of the lookup list matters: put narrow terms such as “furnace repair” above broad ones such as “repair”, or every furnace keyword ends up tagged as general repair. XLOOKUP is not available in Excel 2016 or 2019; Exceljet gives an INDEX and MATCH version for those.

    Here is an illustrative lookup list for a Calgary heating company’s keyword export. It shows the ordering, not real search data.

    Keyword in list (top to bottom) Category
    emergency Urgent
    furnace repair Furnace repair
    furnace Furnace other
    calgary Local
    cost Price research

    With this order, “emergency furnace repair calgary” is tagged Urgent, “furnace repair cost” is tagged Furnace repair, and “furnace installation” falls through to Furnace other. A keyword that matches nothing gets “Unsorted”, which is the list you read by hand. Each row gets one category only, so if a keyword needs several tags, use a separate ISNUMBER(SEARCH()) flag column for each.

    The second meaning is a reusable list of keywords you pick from instead of typing. A Data Validation drop-down list, pointed at a column of approved keywords, does this and keeps the spelling consistent. The third is the workbook’s own Keywords property, also called Tags, which you edit under File > Info. That property describes the file so it is easier to find later, and it does nothing to the cells inside it.

    Man walking along a winding road past an orange traffic cone

    Why Excel misses a keyword that is there

    When a search comes back empty and you can see the word on screen, the cause is usually one of the five below, and they are quick to rule out in this order.

    • A filter is on. Microsoft notes that the Find dialog searches only the rows a filter is showing. Clear the filters and search again.
    • Extra spaces. A trailing space does not stop a normal Find, but it does stop Match entire cell contents and any exact formula such as =COUNTIF(A:A,"calgary seo"). TRIM removes extra spaces, but by itself it does not remove the nonbreaking space (character 160) that often arrives in data copied from web pages. =TRIM(SUBSTITUTE(A2,CHAR(160)," ")) handles both.
    • Match case or whole-cell matching is ticked. Open Options in the Find dialog and check both boxes, because either one narrows the search far more than a plain keyword lookup needs.
    • The keyword is produced by a formula. Set Look in to Values rather than Formulas, so that Find searches the values the cells show rather than the formulas behind them.
    • The keyword contains a wildcard character. In a search for “what is seo?” the question mark stands for any single character, so the search can also return “what is seos”; type what is seo~? to find only the literal question.

    To highlight matches rather than list them, select the keyword column and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Every cell holding the word is coloured, which is often enough when you only need to scan a few hundred rows.

    Man studying a keyword dashboard with volume, trend and intent charts

    Summarize the export with a PivotTable

    Once each row has a tag, a PivotTable shows the shape of the whole export. Insert a PivotTable, drag the category column into Rows and the search volume column into Values as a sum, and you can see at a glance which group carries the demand. Before you sum anything, remove duplicate keywords with Data > Remove Duplicates, because exports merged from several tools often repeat the same term and double its volume. Volume figures are estimates from whichever tool produced them, so treat the totals as a way to rank groups against each other rather than as a forecast of traffic.

    A PivotTable does not always update itself when the data changes. Microsoft’s current page says older versions do not refresh automatically, and that Auto Refresh for PivotTables built on data in the same workbook is so far available to Microsoft 365 Insider participants. Everywhere else, select the PivotTable and press Alt+F5 (or select Refresh on the PivotTable Analyze tab), or open PivotTable Options and tick Refresh data when opening the file on the Data tab. Once the totals are right, the next job is to decide what to do with the list: which page each group belongs on and which groups are worth a page at all.

    Where the spreadsheet stops

    Excel is very good at finding, flagging and counting keywords, and every method above runs on data you already have. What it cannot tell you is which of those keywords a business should go after, which ones already have a page on the site, and which ones are better bought through Google Ads while the organic work takes its months. That judgement is the part of keyword research that a formula does not do.

    SEO Company To-The-TOP! was founded in Calgary in 2007 and works on SEO and Google Ads, and the person who reviews the keyword list is the person who does the work. If you would like a second opinion on your keyword research or your site, call (403) 308-5949.

    Contact Calgary SEO Company To-The-TOP!

    Questions about anything in this article, or about your own rankings? Talk to a Calgary SEO specialist directly.

    Phone: (403) 308-5949
    Address: 1509 14 Ave SW, Calgary, AB T3C 0W4

    Hours:
    Monday to Friday: 10:00 am – 7:00 pm
    Saturday: 12:00 pm – 4:00 pm
    Sunday: closed