Change column width by dragging the border

The fastest way to resize a column is to position your cursor on the border between two column headers, then drag left or right. Click on the line between the column letters at the top of the sheet — your cursor will change to a resize arrow. Drag to make the column wider or narrower. Release when the column reaches the width you want.

This method works for single columns. If you want to resize multiple columns at once, select them first by clicking one column header, holding Shift, and clicking another. Then drag the border of any selected column and all of them will resize together. This is especially useful when you have several columns with similar content that should be the same width.

Set exact column width with the menu

Right-click on a column header and select Resize column. A box will appear where you can type a specific width in inches. This is useful when you need columns to be exactly the same size or when you want to match a particular measurement. Google Sheets measures column width in inches, with 0.5 inches as the minimum width allowed.

You can also select multiple columns first, then right-click and choose Resize column. Enter the width you want and all selected columns will change to that exact size. This approach is better than dragging when precision matters — for instance, if you're building a spreadsheet that will be printed or shared with specific formatting requirements.

Change row height by dragging

Row height works the same way as column width. Position your cursor on the border between two row numbers on the left side of the sheet. Your cursor will change to a resize arrow. Drag up to make the row shorter or down to make it taller. This is the quickest method when you just need a row slightly taller to fit wrapped text or larger font.

If you need the same height across multiple rows, select the rows first by clicking one row number, holding Shift, and clicking another. Then drag the border of any selected row and they will all resize together. This saves time when you're formatting a header row or a section of your spreadsheet that should have consistent spacing.

Set exact row height with the menu

Right-click on a row number and select Resize row. Type the exact height you want in inches. This is helpful when you're building a template and need consistent spacing, or when you're matching a printed document format. The minimum row height is 0.25 inches, which allows for very compact layouts if needed.

Select multiple rows by clicking one row number, holding Shift, and clicking another. Then right-click and choose Resize row to set them all to the same height at once. Using the menu method for rows is particularly useful when you're working with a large spreadsheet and want to may support all data rows have identical heights without the guesswork of dragging.

Auto-fit columns and rows to content

Google Sheets can automatically adjust column width or row height to fit whatever you put in the cell. Select the column or row you want to auto-fit, right-click, and choose Resize column or Resize row. Then click Optimal width or Optimal height. Google Sheets will measure your content and set the size just large enough to display everything without extra space.

This is faster than dragging when you have many columns with different content sizes. If you select multiple columns or rows before using optimal sizing, they will each resize to fit their own content independently — not all become the same size. This is the best option when you've just entered data and want the spreadsheet to look clean and readable without manual adjustment.

Key Takeaways

  • Drag the border between column letters or row numbers to resize quickly without opening a menu.
  • Right-click a column or row header and select Resize to enter an exact measurement in inches.
  • Use Optimal width or Optimal height to let Google Sheets automatically fit the size to your content.
  • Select multiple columns or rows first if you want them all to change to the same size at once.
  • The minimum column width is 0.5 inches and the minimum row height is 0.25 inches.

Frequently Asked Questions

Can I set a minimum or maximum column width?

Google Sheets does not have a built-in minimum or maximum width setting beyond the absolute minimum of 0.5 inches for columns. If you need columns to stay within a specific range, you will need to manually check them, but the basic resizing tools do not enforce limits automatically.

What happens to my data if I make a column too narrow?

The data stays in the cell — it just does not display. If a number or text is too wide for the column, you will see part of it or a truncated view. Make the column wider to see the full content again. The information is not deleted, only hidden from view.

Does resizing one column affect the others?

No. Each column and row is independent. Resizing one column does not change any other column width. The same applies to rows — making one row taller does not affect the height of other rows.

Can I resize all columns at once to the same width?

Yes. Click the box in the top-left corner where the row numbers and column letters meet to select the entire sheet. Then right-click and choose Resize column. Enter the width you want and every column will change to that size.

How do I undo a resize if I made a mistake?

Press Ctrl+Z (or Cmd+Z on Mac) to undo the last resize. You can undo multiple times to go back through your recent changes. If you want to reset to Google Sheets' default sizing, select the column or row and use Optimal width or Optimal height to let it size itself to the content.