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

Space rows and columns evenly in spreadsheets & tables



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

You can also resize tables in Google Docs or Slides so that each row or column is evenly spaced.

Note: Use these instructions for Docs, Slides, and Sheets on your computer. If you're using a mobile device, go to Add and edit tables or Edit & format a spreadsheet.


Expand all  |  Collapse all

Evenly space rows and columns in Sheets

  1. On your computer, open a spreadsheet in Google Sheets.
  2. In the top-left corner of your sheet, click the button to select all cells.
  3. To resize all 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 all rows, drag the row border in the row bar.
  4. To resize all 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 all 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.

Evenly space table rows and columns in Docs and Slides

  1. On your computer, open your Google Docs or Slides file.
  2. Make sure you have permission to edit the file and you are not in Suggesting mode.
  3. Place your cursor in the table whose rows or columns you want change.
  4. Click Formatand thenTableand thenDistribute rows or Distribute columns.


Related topics

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