Fix Bold Formatting in Excel Cells with Wrap Text Enabled
Question details
The user needs copied text to display in bold 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.
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.
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.
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.
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.
Select the affected cell and open Home > Conditional Formatting > Manage Rules. Review rules that apply to the cell and check their font formatting.
With the cell selected, open Home > Cell Styles and inspect the applied style. Try a standard style, then reapply Bold and Wrap Text.

Copy Cell Formatting and Reapply Bold in VBA
Use this method if a VBA macro copies the text and the destination should always be bold.
Check Manual Paste Options in Excel
Use this approach when copying and pasting cells manually.
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.

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.




