The fastest way to change a column width

To change a column width in Excel, position your cursor on the border between two column headers until it turns into a resize arrow, then drag left or right to the width you want. This works in all versions of Excel on Windows and Mac.

If you want a column to fit its content automatically, double-click that same border instead of dragging. Excel will expand or shrink the column to match the longest entry in it.

For precise control — when you need a column exactly 2 inches wide or 20 characters wide — right-click the column header, select Column Width or Optimal Width, and enter a number. This method is faster than dragging when you know the exact size you need.

Key Takeaways

  • Drag the border between column headers to resize; double-click that border to auto-fit the column to its content.
  • Right-click a column header and choose Column Width to set an exact width in character units.
  • Select multiple columns first if you want them all to be the same width, then resize one and all will change together.
  • The Format menu in the ribbon also contains column width options if you prefer not to right-click.

Dragging the column border (the most common method)

Move your mouse to the line between two column letters at the top of the spreadsheet — for example, between the A and B headers. Your cursor will change to a double-headed arrow pointing left and right. This is the resize cursor.

Click and hold, then drag to the right to make the column wider or to the left to make it narrower. Release the mouse button when the column reaches the width you want. The column will stay at that width until you change it again.

This method works when ready and requires no dialog boxes. It is the fastest way if you can see roughly how wide you need the column to be.

Auto-fitting a column to its content

Double-click the border between two column headers instead of dragging. Excel will measure the longest text or number in that column and expand or shrink it to fit exactly.

This is useful when you paste data and the columns are too narrow to read, or when you delete text and want to reclaim space. The column will be as narrow as possible while still showing all content.

If a cell contains a formula that returns a very long result, or if you have a header that is longer than the data below it, auto-fit will size the column to whichever is longest.

Setting an exact column width with the right-click menu

Right-click on any column header — the letter at the top — and a menu will appear. Select Column Width from the list.

A dialog box will open with a text field. Type the width you want in character units. For example, entering 15 will make the column 15 characters wide. Click OK and the column will resize to that exact width.

This method is precise and repeatable. If you need multiple columns to be the same width, you can set them one at a time or select all of them first, then right-click and set the width once — all selected columns will change together.

Using the Format menu from the ribbon

Click the Format menu in the ribbon at the top of Excel. A dropdown will appear with several options related to cells and columns.

Look for Column Width or Optimal Width. Column Width opens the same dialog as right-clicking, where you enter a number. Optimal Width does the same thing as double-clicking the column border — it auto-fits the column to its content.

Some versions of Excel also show AutoFit Column Width in this menu. All three terms refer to the same auto-fit behavior.

Resizing multiple columns at once

Click on the first column header you want to resize, then hold Shift and click on the last column in the range. All columns between them will be highlighted in blue.

Now drag the border of any of the selected columns, or right-click and choose Column Width. All selected columns will resize to the same width. This saves time when you have many columns that should be uniform.

You can also select all columns in the sheet by clicking the box in the top-left corner where the row numbers and column letters meet. Then resize or auto-fit, and every column will change.

Undoing a column width change

If you resize a column and then realize it was the wrong width, press Ctrl+Z (Windows) or Command+Z (Mac) to undo. Excel will restore the column to its previous width.

You can undo multiple steps in a row if you made several column changes. Keep pressing the undo shortcut until the columns are back where you want them.

Frequently Asked Questions

Why does my column show ### instead of the number or text?

The column is too narrow to display the content. Double-click the border between that column and the next to auto-fit, or drag the border to the right to make it wider. The ### symbols will disappear once the column is wide enough.

Can I set a minimum or maximum column width?

Excel does not have a built-in minimum or maximum width setting. You can only set a specific width or auto-fit. If you need a column to stay a certain width, set it manually and avoid auto-fitting, or document the width so you can reset it if someone changes it.

Does changing column width affect the data in the cells?

No. Column width only changes how the data is displayed on screen and in print. The actual data in the cells stays the same. If you make a column very narrow, the text may be hidden, but it is still there — widening the column will show it again.

What is the difference between column width and column height?

Column width controls how wide the columns are left to right. Row height controls how tall the rows are top to bottom. You resize row height by dragging the border between row numbers on the left side of the sheet, using the same drag-and-double-click method as columns.

Can I save a default column width for new spreadsheets?

Excel does not offer a way to set a default column width that applies to all new sheets. You can resize columns in a blank template, save it, and use that template to start new sheets with your preferred widths already set.