wrap txt

guest · Apr 5th, 2002, 12:45 PM

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 · Apr 5th, 2002, 12:48 PM

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 · Apr 5th, 2002, 12:49 PM

yes thats what i am looking for thanks

daleyman · Apr 5th, 2002, 03:01 PM

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.

Apr 5th, 2002, 12:48 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 12:45 PM	#1
guest Board Regular Join Date: Feb 2002 Posts: 91	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

Apr 5th, 2002, 12:49 PM	#3
guest Board Regular Join Date: Feb 2002 Posts: 91	yes thats what i am looking for thanks

Apr 5th, 2002, 03:01 PM	#4
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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.