Chat with us, powered by LiveChat

Adjust Row Height and Column Width

How to Adjust Row Height and Column Width in Google Sheets

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.

    How to Adjust Row Height or Column Widht Manually in Google Sheets.

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.
    How to Adjust Row Height or Column Widht Automatically in Google Sheets.

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.
    How to Specify a Row Height or Column widht in Google Sheets.
  3. In the dialog box that opens, you can choose to specify a precise size in pixels, or automatically set the row or column size based on its contents.

  4. Enter a row height or column width, in pixels.
  5. Click OK.
    How to Specify a Row Height or Column widht in Google Sheets.

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

FREE Quick Reference

Click to Download