Forum Discussion

Henry_Knox's avatar
Henry_Knox
Copper Contributor
Mar 16, 2022

Wrap text formatting not working

Hello friends I've checked the wrap text box under format>alignment and it's not doing as requested. Any suggestions are welcomed.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Henry_Knox 

    If the “Wrap Text” formatting option is not working as expected in Excel, there are a few things you can check:

    1. Make sure that the cell is wide enough to display the wrapped text. If the cell is too narrow, the text may not wrap correctly.
    2. Check the cell’s formatting to make sure that the “Shrink to fit” option is not selected. This option can prevent text from wrapping by shrinking the font size to fit the cell.
    3. Make sure that the cell’s row height is set to “Auto” or is tall enough to display the wrapped text. If the row height is too small, the text may not wrap correctly.
    4. Check for any custom formatting or conditional formatting that may be overriding the “Wrap Text” setting.

    If none of these solutions work, you may want to try clearing all formatting from the cell and reapplying the “Wrap Text” setting to see if that fixes the issue.

     

    I hope this helps!

    Here is a link with information on how you can get a quick and precise solution proposal.

    Welcome to your Excel discussion space!

  • brisbencenter's avatar
    brisbencenter
    Copper Contributor
    Same issue. Need text to wrap. Box checked. But the text is not wrapping.

Resources