How to Automatically Adjust Column Width in Excel?

Select the column or columns you want to adjust

Double-click the right border of a column header to AutoFit the width

Select multiple columns and double-click any selected column border to AutoFit all selected columns

Use the Home tab

Click Format in the Cells group

Choose AutoFit Column Width

Select the entire worksheet by clicking the top-left corner or pressing Ctrl+A

Double-click any column boundary to AutoFit all columns in the sheet

Use the keyboard shortcut Alt, H, O, I to AutoFit the selected columns

Use VBA with `Columns.AutoFit` to adjust column widths automatically

Set text wrapping if you want row height to adjust instead of widening columns

Suggested for You

Trending Today