Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Space spreadsheet rows & columns evenly in Google Sheets

""

In Google Sheets, you can resize all rows, or all columns, to use the same amount of space.

Tips

Use these instructions for Google Sheets on your computer. If you're using a mobile device, go to Edit & format a spreadsheet.

""

Expand all  |  Collapse all

Evenly space rows & columns in Sheets

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the rows or columns you want to resize.
    Tip: To select all rows and columns in the sheet, click the button in the top left corner of the sheet.
  3. To resize rows:
    1. Point to a row border on the numbered row bar. The pointer changes to a vertical arrow.
    2. To change the height of selected rows, drag the row border in the row bar.
  4. To resize columns:
    1. Point to a column border on the column-heading bar. The pointer changes to a horizontal arrow.
    2. To change the width of selected columns, drag the column border in the heading bar.

""

Format cells to automatically expand to show content in Sheets

In Sheets, you can format cells to automatically expand to show content. You can also set content to flow into adjacent empty cells without expanding cell size.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to format.
  3. Click Formatand thenWrapping, then select an option:
    • Overflow—Allow content to flow into adjacent empty cells. Overflow saves vertical space and shows as much content as possible.
    • Wrap—Automatically expand cells to show all content. Wrap lets you view all content in selected cells.
    • Clip—Hide content that doesn't fit in existing cells. Clip shows only the content that fits in the cell.

Related topics

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
false
false