Formatting Issues

Format Different Parts of Text in One Excel Cell

Anum MushtaqAnum Mushtaq Nov 18, 2026 868 views

Question details

The user wants to apply different formatting to individual words or characters within one Excel cell.

Format Different Parts of Text in One Excel Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants some text in a cell to appear bold, italic, or otherwise styled differently from the rest.
Observed behavior
Manually entered text can have mixed formatting, but a formula result cannot normally retain different font styles within its returned text.
Before you start

Select the cell and check the formula bar. If its contents begin with an equals sign, the displayed text is a formula result and needs a different approach.

Solution 1Recommended

Format selected characters in a manually entered cell

Use this method when the cell contains text entered directly rather than a formula.

1
Edit the cell

Double-click the cell, or select it and click inside the formula bar.

2
Select the text

Drag over the words or characters you want to format.

3
Apply formatting

On the Home tab, click Bold or Italic, or choose another available font option. Press Enter to finish editing.

Format selected characters in a manually entered cell
WPS Spreadsheets

Format individual words in a cell with WPS Spreadsheets

Use WPS Spreadsheets to select and format part of a manually entered cell, or paste a formula result as a value before styling it.

  1. 1. Open the spreadsheet: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Edit the cell: Double-click a cell containing manually entered text.
  3. 3. Select the characters: Drag over the word or characters you want to change.
  4. 4. Apply the style: Click Bold or Italic on the Home tab, then press Enter to finish.
Apply bold or italic formatting to selected text within a cellOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet controls in a free Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I bold just one word in an Excel cell?

Yes. Double-click a cell containing manually entered text, select the word, and click Bold on the Home tab.

Why can't I format part of a formula result?

Excel formulas return a value rather than rich text with individual character styles. Use separate cells for dynamic components or paste the result as a value before formatting it.

Will a pasted formula result update automatically?

No. Home > Paste > Values creates a static value. Keep the formula in another cell if you still need a result that updates.

Can VBA format individual characters in a cell?

Yes. VBA can use a cell's Characters.Font property to format selected characters in static text. It does not preserve mixed formatting within a live formula result.