Change cell size by dragging the column or row border

The fastest way to resize a cell is to grab the border between two column letters or row numbers and drag it. Excel will expand or shrink that column or row to whatever width or height you pull it to.

To widen a column: position your cursor on the line between two column letters at the top of the sheet (for example, between the A and B headers). Your cursor will change to a resize arrow — a double-headed line pointing left and right. Click and drag to the right to make the column wider, or to the left to make it narrower. Release when the column is the size you want.

To make a row taller: do the same thing with the line between two row numbers on the left side of the sheet. Position your cursor between the row numbers, wait for the resize arrow to appear, then drag up or down.

Auto-fit a column or row to match your content

If you have text or numbers that don't fit in a cell and you don't want to manually drag, Excel can automatically size the column or row to fit what's inside. Double-click the border between two column letters (or row numbers) and Excel will expand that column (or row) just enough to show all the content.

You can also select a column or row first, then use the menu. Right-click the column letter or row number you want to resize, then click Optimal Column Width (for columns) or Optimal Row Height (for rows). Excel will adjust it automatically.

If you want to auto-fit multiple columns at once, click the column letter of the first column, then hold Shift and click the last column you want to resize. Right-click and choose Optimal Column Width. All selected columns will resize to fit their content.

Set an exact cell size using the Format menu

Sometimes you need a column to be a specific width or a row to be a specific height — for example, to match a template or print layout. You can type in an exact measurement instead of dragging.

To set column width: right-click the column letter, then click Column Width. A small box will appear. Type the width you want (measured in character units — roughly how many average letters fit across). Click OK.

To set row height: right-click the row number, then click Row Height. Type the height you want (measured in points, where 72 points equals one inch). Click OK.

If you want to use the ribbon menu instead of right-clicking, go to the Home tab, click Format (in the Cells group), then choose Column Width or Row Height from the dropdown.

Make text wrap inside a cell instead of resizing

If you have a long piece of text and you don't want to make the column wider, you can tell Excel to wrap the text onto multiple lines within the same cell. This makes the row taller automatically to fit all the text.

Select the cell or cells with text you want to wrap. Go to the Home tab, click Wrap Text (in the Alignment group). The text will now break into multiple lines inside the cell, and the row height will expand to show it all.

To turn off text wrapping, select the cells again and click Wrap Text a second time to toggle it off.

Resize all columns or rows at once

If you want every column in your sheet to auto-fit at the same time, click the Select All button — the small box in the top-left corner where the column letters and row numbers meet. Then double-click any border between two column letters. All columns will resize to fit their content.

You can also select all cells and then right-click a column letter and choose Optimal Column Width. The same works for rows: select all, right-click a row number, and choose Optimal Row Height.

Key Takeaways

  • Drag the border between column letters or row numbers to resize manually, or double-click the border to auto-fit the content.
  • Right-click a column letter or row number and choose Optimal Column Width or Optimal Row Height to resize multiple columns or rows at once.
  • Use Column Width or Row Height from the right-click menu to set an exact size by typing a number.
  • Turn on Wrap Text from the Home tab to make text break into multiple lines within a cell instead of expanding the column.

Frequently Asked Questions

Why is my text cut off even though I made the column wider?

The column is wide enough, but the text is still hidden. This usually means the cell to the right has content in it. Excel only shows overflow text if the next cell is empty. Click the cell with the hidden text and check the formula bar at the top to see the full content. You can also widen the column more, or turn on Wrap Text to display it all.

Can I resize a column to a specific number of pixels?

Excel measures column width in character units, not pixels, so you cannot set an exact pixel width through the standard menu. If you need pixel-perfect sizing, you can use a macro or VBA code, but for most work, character units or dragging to the size you want is sufficient.

What's the difference between column width and optimal column width?

Column width is what you set manually — you type a number. Optimal column width is what Excel calculates automatically to fit the longest piece of content in that column. Optimal is faster if you just want things to look neat; manual width is better when you need a specific size for formatting or printing.

If I resize one column, does it affect the others?

No. Resizing one column does not change any other column. Each column is independent. If you want to resize multiple columns to the same width, select them all first, then right-click and choose Column Width, and type the width you want.

How do I make a row shorter if the text is wrapped?

Turn off Wrap Text for that row, or manually drag the row border up to make it shorter. If you turn off wrapping, the text will go back to a single line and may overflow into the next cell (if that cell is empty) or be hidden (if the next cell has content).