AjapaReporter

Home life · Updated

How to Stretch Out Cells in Excel: 6 Ways

Time it takes5 min
Steps6in the list below
LevelEasyno special skills
Official sourceMicrosoft Supportcheck it for changes

Quick answer To stretch out cells in Excel, select the column or row, then drag the boundary or use AutoFit to automatically resize it to fit the content.

What You’ll Need

  • Microsoft Excel (any recent version, desktop or web)
  • A spreadsheet with data in the cells you want to resize

Step-by-Step

  1. Select the column or row. Click the letter at the top of the column (e.g., “A”) or the number on the left of the row (e.g., “1”). To select multiple, click and drag across the letters/numbers, or hold Ctrl (Cmd on Mac) while clicking.
  2. Drag the boundary to stretch manually. Move your cursor to the right edge of the column header (or bottom edge of a row header) until it turns into a double-headed arrow. Click, hold, and drag to the desired width or height. Release to set the size.
  3. Use AutoFit for automatic stretching. Double-click the right edge of a column header (or bottom edge of a row header) to instantly resize it to fit the longest content in that column/row. This is the fastest way to make all content visible.
  4. Stretch multiple columns/rows at once. Select multiple columns (or rows), then double-click any boundary between them. All selected columns/rows will resize to fit their own content.
  5. Set an exact size. Right-click the selected column/row header and choose “Column Width” or “Row Height.” Enter a number (in characters for columns, points for rows) and click OK. For columns, you can also use the Format menu: Home > Format > Column Width.
  6. Stretch all cells to fit the entire sheet. Click the triangle at the top-left corner (where column A and row 1 meet) to select the whole sheet, then double-click any column boundary to AutoFit all columns, and any row boundary to AutoFit all rows.

Common Mistakes

  • Dragging the wrong edge. Make sure you grab the boundary between column letters, not the letter itself. Dragging the letter moves the entire column.
  • AutoFit not working. If you double-click and nothing changes, the column may already be wide enough, or the cell contains wrapped text (see Troubleshooting).
  • Accidentally changing multiple columns. If you have multiple columns selected and drag one boundary, all selected columns get the same width, which may not be what you want.

Tips

  • Use keyboard shortcuts. Select a column and press Alt+H+O+I to AutoFit column width, or Alt+H+O+A for row height (Windows). On Mac, use the menu: Home > Format > AutoFit Column Width.
  • Wrap text for long entries. Instead of making a column extremely wide, select the cell(s), go to Home > Wrap Text. This keeps the column narrow but shows all content on multiple lines.
  • Set a default width. To change the default width for all new columns, go to Home > Format > Default Width. This is useful if you often find columns too narrow.
  • Save time with a double-click. AutoFit is the most efficient method for most cases. It’s especially handy after pasting data from another source.

Troubleshooting

  • AutoFit doesn’t fit merged cells. Excel cannot AutoFit a row that contains merged cells. Unmerge the cells (select them, go to Merge & Center to toggle off), then AutoFit, or manually adjust the row height.
  • Content still cut off after AutoFit. If the cell has wrap text enabled and the row height is set to a fixed value, AutoFit may not adjust it. Select the row, right-click > Row Height, and click OK (without changing the number) to reset it to auto.
  • Dragging is too imprecise. Use the exact size method (Step 5) to enter a precise number. You can also hold Alt while dragging to snap to gridlines, which helps align columns.
  • Changes don’t apply to all sheets. If you want the same width on multiple sheets, group the sheets first: hold Ctrl and click each sheet tab, then resize. Remember to ungroup afterward.

Frequently Asked Questions

How do I make all columns the same width?

Select all columns by clicking the triangle at the top-left corner, then drag any column boundary to the desired width. All columns will match that width.

Why is my text cut off even after AutoFit?

This usually happens when the cell has wrap text enabled but the row height is fixed. Reset the row height to auto by selecting the row, right-clicking, and choosing Row Height, then clicking OK without changing the value.

Can I stretch cells to fit the page when printing?

Yes. Go to Page Layout > Scale to Fit, and adjust the width/height to 1 page. This doesn’t change the on-screen cell size but scales the printout.

What’s the difference between column width and row height?

Column width is measured in characters (the number of standard font characters that fit), while row height is measured in points (1/72 of an inch). Both can be set manually or with AutoFit.

Does AutoFit work with numbers and dates?

Yes, AutoFit adjusts to the displayed content, including numbers and dates. However, if the number is formatted with many decimals, it may still be cut off—consider changing the number format instead.

How do I stretch a single cell without affecting the whole column?

You can’t change the width of a single cell independently; it’s tied to its column. To make one cell wider, you can merge it with adjacent cells (select the cells, then Merge & Center).

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.