|
|
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.
Evenly space rows and columns in Sheets
- On your computer, open a spreadsheet in Google Sheets.
- In the top-left corner of your sheet, click the button to select all cells.
- To resize all rows:
- Point to a row border on the numbered row bar. The pointer changes to a vertical arrow.
- To change the height of all rows, drag the row border in the row bar.
- To resize all columns:
- Point to a column border on the column-heading bar. The pointer changes to a horizontal arrow.
- 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.
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to format.
- Click Format
Wrapping, 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
|
