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

Space rows and columns evenly in tables and spreadsheets

""

Tips

As you edit tables in Google Docs or Slides, the spacing of rows and columns might become uneven. You can resize table rows and columns so that each one uses the same amount of space.

You can also evenly space all spreadsheet rows and columns in Google Sheets.

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.

""

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 edit access to 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.

""

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.To resize all rows:
    1. Point to a row border on the numbered row bar. A vertical arrow appears.
    2. To change the height of all rows, drag the row border in the row bar.
  3. To resize all columns:
    1. Point to a column border on the column heading bar. A horizontal arrow appears.
    2. To change the width of all columns, drag the column border in the heading bar

""

Format cells to automatically expand or clip content in Sheets  

In Sheets, you can format cells to automatically expand to show all the content. You can also set content to flow into adjacent empty cells without expanding cell size, or hide content that doesn't fit in cells.

  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 see 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