Home › Discussions › Questions & Answers › Scaling Excel Column Widths Globally

Scaling Excel Column Widths Globally

Avatar photoCustomer Questions & Answers 5 replies

Our users find that automatically calculated column widths are slightly too narrow on certain monitors, causing text wrapping. How can I apply a small, global scaling factor to all column widths?

5 replies

  • Support Enginatics

    You can use the profile option ‘Blitz Report XLSX Column Width Scale Percentage’. This allows adjusting the automatically calculated column width, in case the cell content does not fit the width on certain client screen resolutions.

  • Avatar photoCustomer

    What is the default percentage scale?

  • Support Enginatics

    The default scale is 100.

  • Avatar photoCustomer

    If I set the mode to only align with headers, does this scale still apply?

  • Support Enginatics

    The scale percentage applies to the overall automatically calculated column width, regardless of whether the alignment mode is header, data, or both.

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