re size column text data

[#1]

Hi

i am using chart straight table

one of the coulmn is company

I want the that the name of company will look full name automatically ,

without the user need to stretch to the right in order to see the full name.( no matter if it is a short or long name )

in order to solve it i try to use "Wrap cell Text" = 2 line , but i am looking for another way

how do i do that ?

thank you

[Gysbert_Wassenaar]

You can try adding an action to the OnActivate sheet trigger that runs a macro.

Sub FitZoom

    ActiveDocument.ActiveSheet.FitZoomToWindow

End sub

This is not perfect and not exactly what you're looking for, but there is no other option.

[#3]

Hi

I am not allowed to run macro