To highlight just one word in an Excel cell, edit the cell, select only that word, then use Home > Font Color to change its text color or apply another character format. Excel can format individual characters, but it cannot apply cell-fill shading behind only part of a cell’s text; Fill Color affects the whole cell.
The steps below are for Excel for Microsoft 365 on Windows. The same general method works in desktop Excel for Mac, though some keyboard shortcuts differ. Save your workbook first if the text is important, especially before making many manual edits.
What You’ll Need
- Excel for Microsoft 365 on Windows or Mac, with the workbook open and the cell containing the word.
- A clear idea of how you want the word to stand out, such as a different font color, bold, italics, underline, or a combination.
- For a large number of words or repeated changes, consider whether a different layout or a macro is more suitable. Manual character formatting is best for a small number of cells.
Step-by-Step
- Find the cell and note the exact word. Click the cell once to identify it. If the cell contains a sentence or several words, check spelling and punctuation so you know exactly which characters to format. This method changes the appearance of characters, not the cell’s value.
- Enter editing mode. Double-click the cell, or select it and press F2. You should see a text insertion cursor inside the cell rather than a border around the whole cell. If Excel opens the formula bar for editing, you can work with the text there instead.
- Select only the word. Drag across the word’s letters while the cell is being edited. Include punctuation only if you want that punctuation formatted too. Take care not to select the space before or after the word; selecting a space can make the formatting seem wider than intended. If the word occurs more than once, make sure you select the intended occurrence.
- Choose a format while the characters remain selected. On the ribbon, open Home. Choose Font Color to change the letters’ color. Click the arrow next to the Font Color button to pick a specific color from the palette. You can also choose Bold, Italic, or Underline in the Font group. These options can be combined if you want the word to be especially noticeable.
- Check that the selection is still active. The word should remain selected or visibly marked while you apply the formatting. If the selection disappears when you click the ribbon, do not guess which characters changed. Return to editing mode and select the word again, then apply the format. In some Excel layouts, the ribbon can be collapsed; expand it or use the Home tab controls that are visible.
- Finish editing the cell. Press Enter to commit the edit. If you want to finish without moving down to another row, press Tab instead, or click another cell. Avoid pressing Esc unless you intend to cancel the current edit; Esc can discard your changes to the cell.
- Verify the result. Click the cell once and confirm that only the intended word has the new appearance. If the entire cell changed, you probably applied a cell-level setting rather than formatting selected characters. Use Ctrl+Z on Windows to undo immediately, then edit the text and try again. On Mac, use Command+Z.
- Repeat for other words if needed. To format a second word in the same cell, edit the cell again, select the other word, and apply the desired character format. You can use a different color or style for each selection. For many cells, repeated manual formatting can be slow and inconsistent, so consider a more structured approach before continuing.
Windows selection shortcut: If the insertion point is just after a word while editing, Ctrl+Shift+Left Arrow usually selects back to the start of that word. Check the selection before applying formatting because punctuation and spaces can affect what gets selected. On Mac, Option+Shift+Left Arrow is the corresponding word-selection shortcut in many text-editing contexts. Keyboard behavior can vary with the cursor position and keyboard settings, so dragging across the word is the most reliable fallback.
In Excel for Mac, enter edit mode by double-clicking the cell or pressing Control+U in many configurations; keyboard mappings can vary by Mac keyboard and Excel settings. You can also use the formula bar to edit the cell. Then select the characters and use the font formatting controls on the Home tab. Excel for the web supports many ordinary formatting tasks, but its editing and selection behavior can differ from desktop Excel; if it will not preserve a partial-text selection while using the ribbon, open the workbook in the desktop app.
Common Mistakes
- Using Fill Color for a single word. Fill Color paints the background of the cell, not the background behind selected characters. It will color the whole cell. Use Font Color or a character style if the goal is to make one word stand out within the text.
- Selecting the cell instead of its text. A border around a cell means the cell is selected; it does not mean a word inside it is selected. Enter edit mode first and look for the text cursor, then select the letters themselves.
- Replacing or deleting text by accident. Typing while the cell is selected can replace the cell’s contents. If you see the old text disappear, press Esc before committing the change, or undo after an accidental edit. When editing, click or move the insertion point carefully before typing.
- Formatting a space or punctuation unintentionally. A selection that includes adjacent spaces, commas, or periods formats those characters too. Zoom in if necessary and inspect the word after you finish.
- Expecting partial-word background shading. Standard cell formatting does not provide a text-marker effect behind only one word. A cell’s fill is applied to the cell as a whole. Use a font color, bold style, or a separate text box if colored backing is essential.
Tips
- Choose strong contrast. If the cell has a colored fill, choose a font color that remains legible against that background. Avoid pale text on a pale fill or red and green combinations that may be hard for some readers to distinguish.
- Use a restrained style. Bold or a contrasting font color is often enough. Applying several effects to every important word can make a worksheet difficult to scan and can reduce readability.
- Keep text and data structure in mind. Character formatting is visual only. It does not change the cell’s underlying text, make a word searchable as a separate value, or affect calculations. If you need to sort, filter, or analyze words, store the information in separate cells or columns instead.
- Use a comment or a separate cell for longer explanations. A formatted word can signal importance, but it cannot explain why the word matters. Add a note, comment, or adjacent explanation when other users need context.
- Consider accessibility. Do not rely on color alone to communicate meaning. Pair color with bold text, a label, or another clear indicator, and check that the word is still understandable when printed or viewed without color.
- For recurring layouts, standardize the treatment. Decide on one color or style for a particular kind of emphasis and use it consistently. This helps readers understand the worksheet without having to interpret a different visual cue in every cell.
Troubleshooting
The whole cell changed color or style. Undo the change, re-enter editing mode, and select the word rather than the cell. Confirm you can see the character selection, then use Font Color or a character-style button. If the cell border is the only visible selection, you have not selected the text yet.
The text selection vanishes when you click the ribbon. Try selecting the word, then using the small formatting toolbar that appears near the selection if your Excel version displays it. Alternatively, select the word and use a keyboard shortcut for a character style, such as Ctrl+B on Windows or Command+B on Mac for bold. For color changes, return to the Home tab and carefully reselect the text if needed. If the web version continues to lose the selection, use desktop Excel.
The color looks unchanged. Check that the selected characters are not already the chosen color, and confirm the font color rather than the cell fill changed. A theme color may also look different from what you expected. Open the Font Color dropdown and select a clearly contrasting color, then commit the edit and inspect the cell outside edit mode.
Excel will not let you select the word. Make sure the sheet is not protected in a way that prevents editing, and check whether the workbook is read-only. If the cell contains a formula, you may be able to format displayed characters, but editing its contents directly can replace the formula. Do not overwrite a formula just to change its appearance; check the formula bar first and consider formatting a separate label or output instead.
Your formatting disappears after editing. If you re-enter a cell and change its contents, Excel may not preserve the character formatting in the way you expect, particularly when replacing all the text or pasting new content. Reapply the format after the text is final. If another person or process overwrites the cell, the formatting may need to be reapplied as well.
Frequently Asked Questions
Can I highlight a word with a colored background inside a cell?
Not with standard Excel cell formatting. Fill Color applies to the entire cell, not just selected characters. To emphasize one word, use font color, bold, or another character style. If you need a colored block behind text, a text box or a separate cell may work better.
Can I change just one word to bold or italics?
Yes. Enter edit mode, select the word’s characters, and choose Bold or Italic on the Home tab. Commit the edit and check that the style affected only the selected text.
Can I format a word inside a formula result?
Excel formulas return a cell value, while character formatting is applied to the cell’s displayed text. You may be able to format selected characters in the displayed result, but the formatting is manual and can be lost or become misleading when the formula result changes. For a dependable layout, consider placing the label or emphasized word in a separate cell.
Can I highlight every occurrence of a word automatically?
Excel does not offer a standard one-click command that applies character formatting to every matching word across cells. Find can locate text, but finding it is not the same as applying partial-character formatting. For repeated emphasis, consider separating the text into cells or using a carefully reviewed macro; always save a copy before running a macro because macro actions cannot be undone with Ctrl+Z.
Does this change the value of the cell?
No. Applying font color, bold, or underline changes appearance only. The text remains the same, so calculations and text searches continue to use the cell’s contents rather than its visual style.
Can I copy the formatting to another word?
You can repeat the same edit-and-select process in another cell. Format Painter is designed to copy formatting, but copying character-level formatting reliably to a different selection can be awkward when the text differs. For a one-off change, reselecting the target word and applying the style directly is usually clearer.
Related
- Google Sheets INDEX MATCH Formula: How to Use It Right
- INDEX MATCH in Google Sheets: Search Another Sheet
- How to Filter Rows in Google Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create Rules in Outlook for iOS: What Works and HowIn Outlook for iOS, you can make a simple rule for a sender by opening one of their…
- Google Sheets COUNTIF Contains: Match Text AnywhereTo count cells in Google Sheets that contain a particular text anywhere, use =COUNTIF(A2:A100,"*apple*"). The asterisks are wildcards:…
- Create Labels in Word for the Web: A Practical GuideTo create labels in Word for the web, download an editable Word template that matches your label-sheet product,…
- Excel Freeze Panes: How Many Rows Should You Select?If Excel freezes too many rows, unfreeze the panes and freeze them again from the cell immediately below…
- How to Create Rules in New OutlookTo create a rule in New Outlook, select Settings (the gear icon) > Mail > Rules > Add…
- Share an Outlook Calendar Externally: Steps and OptionsYes. You can share an Outlook calendar with someone outside your organization by inviting their email address and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.