Is the best way to avoid excel doing auto wrap text is with VBA or something in the settings ?

  • hello experts,

    I just have something like 400 excel files that I wish to not deal with auto text wrap, this function isn't smart at all in my opinion and all it does is making me lose time be readjusting it repeatedly,

    is there any amazing awesome life saving tip to it ?

    I can't believe I'm in excel for such long time and I never consider doing something about it,

    thanks for any help you guys ^_^


  • You can put this in the Open Event of each workbook, or create an addin.

    1. Private Sub Workbook_Open()
    2. Dim oWs As Worksheet
    3. For Each oWs In ActiveWorkbook.Worksheets
    4. oWs.Cells.Select
    5. Selection.WrapText = False
    6. Next oWs
    7. End Sub