Home Discussions Questions & Answers Scaling Excel Column Widths Globally

Scaling Excel Column Widths Globally

Avatar photoCustomer May 19, 2020 at 10:46 pm

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support May 20, 2020 at 2:26 pm  

      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 May 21, 2020 at 1:13 pm  

      What is the default percentage scale?

    • Support May 21, 2020 at 4:54 pm  

      The default scale is 100.

    • Avatar photoCustomer May 23, 2020 at 10:08 am  

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

    • Support May 24, 2020 at 1:44 pm  

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

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

Login with: