Adjust Row Height and Column Width

Every cell in a spreadsheet starts at a standard width and height, but you can easily change a column's width or a row's height to display everything you need.

Adjust Row Height or Column Width Manually

You can manually adjust the row height or column width the same way.

1. Click and drag the border between two rows or columns.

   When you position the cursor over a row or column header's border, a black arrow appears. This needs to be showing before clicking and dragging.

   

The row height or column width are resized.

Adjust Row Height or Column Width Automatically

1. Double-click the border between two rows or columns.
   

The row height or column width is automatically adjusted so that it's tall/wide enough to fit the contents of its largest cell.

Specify a Row Height or Column Width

You can also specify a precise row height or column width.

1. Right-click a row or column header.
2. Select Resize row or Resize column.
   
3. Enter a row height or column width, in pixels.
4. Click OK.
   

The row height or column width is set to the number of pixels we specified.