The fastest way to resize a column

Double-click the line between two column letters at the top of your spreadsheet. Excel automatically fits the column to the width of whatever text or numbers are inside it. This works on any version of Excel — desktop, web, or Mac — and takes one second.

If that does not work for you, or if you need a column wider or narrower than the auto-fit suggests, use one of the two methods below instead.

Key Takeaways

  • Double-clicking the border between column letters auto-fits the column to its content in one action.
  • Dragging the border between column letters lets you set any width you want by hand.
  • Right-clicking a column letter and choosing "Column Width" lets you enter an exact measurement.
  • The web version of Excel (Office 365 online) uses the same double-click and drag methods as the desktop version.
  • Changing one column's width does not affect any other column unless you select multiple columns first.

Dragging the column border to set width by hand

Position your cursor on the line between two column letters at the top of the spreadsheet — for example, between columns A and B. Your cursor will change to a resize arrow (a double-headed line). Click and hold, then drag left to make the column narrower or right to make it wider. Release the mouse button when the column reaches the width you want.

This method gives you full control but requires a steady hand. If you overshoot, just drag again. You can resize multiple columns at once by selecting them first: click one column letter, hold Shift, and click another column letter to select a range. Then drag the border of any selected column, and all selected columns will resize together.

Using the Column Width dialog for exact measurements

Right-click any column letter and select Column Width from the menu. A small box will appear asking you to enter a number. Excel measures column width in character units — the number represents how many characters of the default font will fit across the column. Type a number and click OK.

This method is useful when you need columns to be exactly the same width, or when you are working from a specification that lists column widths as numbers. The default width for most columns is 8.43 characters. If you are not sure what number to enter, start with 15 or 20 and adjust from there.

Auto-fitting multiple columns at once

Select all the columns you want to resize by clicking the first column letter, holding Shift, and clicking the last column letter. Then double-click the border between any two selected column letters. Excel will auto-fit every selected column to its content in one action.

You can also select your entire spreadsheet by clicking the box in the top-left corner (where the row numbers and column letters meet), then double-clicking any column border. This auto-fits every column in the sheet at once, which is useful when you paste data and want everything to fit neatly.

Resizing columns in Excel Online

The web version of Excel (part of Microsoft 365 online) works the same way as the desktop version. Double-click the border between column letters to auto-fit, or drag the border to set width by hand. The right-click menu also includes Column Width if you need an exact measurement.

One difference: Excel Online sometimes takes a moment to register your drag action, so move slowly and deliberately. If the column does not resize, try again. The double-click method is usually faster and more reliable in the web version.

What to do if a column will not resize

If dragging does not work, check whether the column is frozen. Frozen columns have a thicker border line and cannot be resized until you unfreeze them. Go to the View tab, click Freeze Panes, and select Unfreeze Panes. Then try resizing again.

If the column is part of a table (created with the Table feature), the resize methods still work the same way. If you are working in a protected sheet, the owner may have locked column widths. Ask them to unprotect the sheet, or contact your IT department if this is a shared workbook.

Frequently Asked Questions

Can I set a minimum or maximum column width?

Excel does not have a built-in minimum or maximum width setting. You can manually set each column to the width you want using the Column Width dialog, but there is no rule that prevents someone from changing it later. If you need to enforce column widths across a team, use a template file with the columns already sized, or protect the sheet.

What is the difference between column width and optimal width?

Column width is the measurement you set. Optimal width (what Excel calls auto-fit) is the width Excel calculates based on the longest piece of content in that column. Auto-fit usually gives you the most readable result, but if your column contains one very long entry and many short ones, auto-fit may make the column wider than you need.

Does changing column width affect the data inside?

No. Changing column width only changes how the data looks on screen and in print. The actual data stays the same. If a number or text is too wide to fit, it will either spill into the next cell (if the next cell is empty) or be cut off visually — but the full content is still there.

How do I resize all columns to the same width?

Select all columns by clicking the box in the top-left corner of the spreadsheet. Right-click any column letter and choose Column Width. Enter the width you want, and click OK. Every column in the sheet will be set to that width.

Why does my column width look different on someone else's computer?

Column width is measured in character units based on the default font. If someone opens your file with a different font selected, the columns may look wider or narrower because the characters are a different size. To avoid this, use the Column Width dialog to set exact measurements rather than relying on how it looks on your screen.