How to change several columns width at the same time in Excel? same size for all columns?



The width for several columns at the same time. Simply select the columns you would like to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for Row height.


1. Position the mouse over the column line in the column heading so the white cross becomes a double arrow .
2. Double-click the mouse. The column width will be changed automatically to fit the content