Google Sheets can automatically size columns to fit their contents, just like AutoFit in Excel. You can double-click a column border, use Resize columns > Fit to data for many columns at once, and do the same for rows. This guide covers each method, how wrapping affects row height, fixing columns that won’t fit, and what works on phones and tablets.
Quick Answer
Select the columns, right-click a column letter, choose Resize columns, pick Fit to data, and click OK. Or double-click the right border of a column letter.
Method 1: Double-Click the Column Border
- Point to the right edge of the column letter until the cursor becomes a double arrow.
- Double-click. The column resizes to fit its widest cell.
Select several columns first and double-click any selected border to fit them all.
Method 2: Resize Columns > Fit to Data
- Click a column letter, or drag across several. Click the corner box to select every column.
- Right-click a selected letter and choose Resize columns.
- Select Fit to data and click OK.
AutoFit Row Height
- Select the rows by clicking their numbers.
- Right-click and choose Resize rows, then Fit to data.
Rows grow to fit wrapped text and larger fonts. Double-clicking a row border also works.
Wrap Text Instead of Widening
If long text makes columns too wide, keep a fixed width and wrap it: select cells and choose Format > Wrapping > Wrap. Then fit row heights. Clip hides overflow, and Overflow lets text spill into empty neighbors.
Set an Exact Width
In Resize columns, choose Enter new column width in pixels and type a number (the default is 100). Use the same value for consistent layouts. Related: how to make multiple columns the same width.
On iPhone, iPad and Android
- Tap a column letter to select it, then drag the border to resize.
- Some app versions show Resize or Fit to data when you tap and hold the column letter; availability varies by device.
- For many columns, Fit to data on a computer is quicker.
Why a Column Doesn’t Fit
| Problem | Fix |
|---|---|
| Column barely changes | Text is wrapped; set wrapping to Overflow or Clip first |
| Numbers show as #### | Widen the column or reduce decimal places |
| Fits to a header, not data | A long header or title is the widest cell; wrap it or merge it across columns |
| Merged cells ignored | Fit to data skips merged cells; size those manually |
Excel Comparison
Excel’s equivalent is Home > Format > AutoFit Column Width. Excel can also shrink text to fit a cell; see how to shrink text to fit inside a cell in Excel.
After resizing, you can center data horizontally in Google Sheets.
Related: highlight every other row in Google Sheets.
Related: skip a line in a Google Sheets cell.
Related: Adjust column width in Google Sheets.
Related: Show all text in a Google Sheets cell.
Frequently Asked Questions
Does Sheets autofit automatically as I type?
No. Columns keep their width until you resize them. Rows grow automatically for wrapped text in many cases.
Is there a keyboard shortcut?
No built-in shortcut. Use the menu or double-click.
Summary
- Double-click a column border to fit it.
- Right-click > Resize columns > Fit to data for many columns.
- Use Resize rows > Fit to data for rows.
- Wrap long text instead of making columns very wide.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.