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

Capping the Maximum Width of Excel Columns

Avatar photoCustomer Questions & Answers 5 replies

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?

5 replies

  • Support Enginatics

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

  • What is the default maximum width value?

  • Support Enginatics

    The default maximum column width is 60.

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

  • Support Enginatics

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

  • You must be logged in to reply to this post.