wrap txt

[guest]

when i wrap text some rows are wide and some are not wide i have to go and do each one auto fit how to do all autofit at once

 

[Al Chara]

Not sure if this is what you are looking for, but try the following:

Selection.Columns.AutoFit

It autofits the column width of your entire selection.

 

[guest]

yes thats what i am looking for thanks

 

[daleyman]

thats in vba, you can do it manually by selecting the "all sheets" button which is in the corner to the left of the column A heading and above the Row 1 label. This selects all the sheets, then double click the edge of one of the column headers it will autofit all columns on the sheet.