Set Maximum Column Width - without effecting columns smaller than max

[RogerC]

I regularly run a report that outputs 200 or more columns. Around 30 of those columns may be up to 255 characters wide. Most other columns are output as an acceptable column width of around 20 characters wide.
Typically, I zoom way out, manually highlight all the too-wide columns and adjust their width to 40 characters.

Without using VBA, is there any way to quickly adjust all column widths across the 200 columns to a maximum of 40 characters wide without also increasing the narrower columns to 40?

 

[Fluff]

Not that I know of. You would either need vba, or do it manually.

 

[EXCEL MAX]

I guess, you know the width of characters is not same, so the width of column depends which characters are in the columns.
But you can try this.

Press Ctrl + G to open "GoTo" dialog.
In the reference put the columns (separated by comma) that you want to resize.
Press "OK" and when all columns are selected resize all to the optimum as one.
I did't test it how many columns you can resize at once.