How To Make Excel Cells Expand To Fit Text?

Select the cells, rows, or columns you want to adjust

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

Double-click the bottom border of a row header to auto-fit the row height

Select the range, then go to Home > Format > AutoFit Column Width

Select the range, then go to Home > Format > AutoFit Row Height

Turn on Wrap Text from Home > Alignment to make text display on multiple lines

Manually drag the column or row borders to resize cells

Use Format Cells > Alignment > Wrap text for selected cells

Press Alt + H, O, I to auto-fit column width

Press Alt + H, O, A to auto-fit row height

Suggested for You

Trending Today