Formatting Issues

Fix Bold Formatting in Excel Cells with Wrap Text Enabled

Huda QurayshiHuda Qurayshi Nov 18, 2026 870 views

Question details

The user needs copied text to display in bold in Excel cells with Wrap Text enabled.

Fix Bold Formatting in Excel Cells with Wrap Text Enabled
Product
Microsoft Excel
Device & OS
not provided
Scenario
Text is copied into destination cells that use Wrap Text, possibly through a VBA procedure.
Observed behavior
The Bold control appears selected, but the copied text does not display in bold.
Before you start

Confirm your Excel version and platform, since menus and VBA availability vary. Identify the destination cells and whether you copy the text manually or with a macro.

Solution 1Recommended

Test Bold Formatting and Inspect Cell Rules

Use this approach to determine whether the issue is caused by cell formatting rather than the copy procedure.

Wrap Text does not normally prevent bold formatting. Conditional formatting, cell styles, or formatting applied to individual characters can affect how the text appears.

1
Test the destination cell

Select a destination cell, turn Home > Wrap Text off, and click Home > Bold. Turn Wrap Text back on and check whether the text remains bold.

2
Check character formatting

Double-click the cell or select its text in the formula bar, highlight the affected characters, and click Home > Bold to apply bold directly to them.

3
Inspect conditional formatting

Select the affected cell and open Home > Conditional Formatting > Manage Rules. Review rules that apply to the cell and check their font formatting.

4
Check the cell style

With the cell selected, open Home > Cell Styles and inspect the applied style. Try a standard style, then reapply Bold and Wrap Text.

Test Bold Formatting and Inspect Cell Rules
Free Microsoft Office alternative

Format Wrapped Spreadsheet Text with WPS Office

WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar spreadsheet interface. Open compatible Excel files and work with cell formatting as you move between applications; it does not repair Excel's own formatting or VBA behavior.

Apply bold and wrap text in WPS SpreadsheetsOpen and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday spreadsheet tasksMove between common Office file formats with a lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Does Wrap Text turn off bold in Excel?

No. Wrap Text should not disable bold. Select the cell and check Home > Bold, then inspect conditional formatting and any formatting applied to individual characters.

Why is my copied text not bold after a values-only paste?

A values-only paste does not copy the source cell's formatting. Use Home > Paste with source formatting, or select the destination and apply Home > Bold afterward.

How can I force a destination range to be bold in VBA?

After the copy or value assignment, use Destination.Font.Bold = True, with Destination set to the target Range. Check conditional formatting if the text still appears different.

Where can I check whether a conditional formatting rule affects the font?

Select the affected cell and open Home > Conditional Formatting > Manage Rules. Review the rules that apply to the cell and inspect their font settings.