Home Discussions Questions & Answers Capping the Maximum Width of Excel Columns

Capping the Maximum Width of Excel Columns

Avatar photoCustomer January 3, 2024 at 10:34 pm

We have some columns with very long content (e.g., descriptions) that cause excessively wide columns in Excel. How can I enforce a maximum column width?

Viewing 4 reply threads
  • Author
    Replies
    • Support January 4, 2024 at 1:14 pm  

      You can set the profile option ‘Blitz Report XLSX Max Column Width’. This defines the maximum column width for Blitz Report XLSX output files.

    • Avatar photoCustomer January 6, 2024 at 3:46 am  

      What is the default maximum width value?

    • Support January 6, 2024 at 6:55 am  

      The default maximum column width is 60.

    • Avatar photoCustomer January 6, 2024 at 12:41 pm  

      If the content exceeds this width, does the text wrap?

    • Support January 8, 2024 at 8:41 am  

      The column width is capped at this maximum, but the generated macro template includes code that attempts to set `WrapText = False`.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: