When data looks cut off or too spread out, resizing columns and rows keeps your sheet neat and easy to read. Google Sheets gives you quick ways to adjust sizes manually or automatically.
Resize Single Column or Row
- Hover over the border of a column letter or row number until the resize arrow appears.
- Click and drag to make it wider or narrower, taller or shorter.
- Double-click the border to automatically fit the size to your data.
Resize Multiple Columns
- Hold Shift and select the column letters you want to resize.
- Hover over one of the selected borders until the resize arrow appears.
- Drag to set the new width in one of the selected column and all selected columns will adjust together to the same width.
Resize Multiple Rows
- Hold Shift and select the row numbers you want to resize.
- Hover over one of the selected borders until the resize arrow appears.
- Drag to set the new width in one of the selected column and all selected columns will adjust together to the same height.