Adjust Column Width and Row Height

Make cut-off text readable by resizing columns and rows — or let AutoFit do it.

You will learn to

• Drag a column border to resize
• Double-click to AutoFit
• Change a row height

How it works

Drag the line on the right edge of a column letter to resize it, or double-click that line to AutoFit the column to its longest entry. Row heights work the same way using the line under a row number. In Excel you can also set an exact size from Home → Format → Column Width.