The Three Ways to Resize a Column

You can change column width in Excel by double-clicking the border between two column headers, dragging that border to a new width, or right-clicking and entering a specific measurement. The double-click method is fastest if you want the column to fit its contents automatically. Dragging works best when you want to set the width by eye. The right-click menu is most precise when you need an exact width or want to set multiple columns to match.

All three methods work the same way in Excel for Windows and Excel for Mac. The column you are resizing is always the one whose right edge you are working with — so to widen column B, you work on the border between the B and C headers.

Key Takeaways

  • Double-click the border between two column headers to make a column automatically fit the width of its longest entry.
  • Drag the border between column headers left or right to set the width by hand, and release when the column looks right.
  • Right-click a column header and select "Column Width" to enter an exact measurement in characters.
  • To resize multiple columns at once, select them first by clicking their headers while holding Ctrl (or Cmd on Mac), then use any of the three methods.

Auto-Fit by Double-Clicking the Column Border

Position your cursor on the line between two column headers at the top of the spreadsheet. The cursor will change to a resize arrow — a double-headed line pointing left and right. Double-click at that spot. Excel will when ready widen or narrow the left column so that all its text fits without cutting off.

This method is the fastest way to clean up a spreadsheet where some columns are too narrow to show their full content. If a column contains a very long entry in just one cell, auto-fit will make the entire column wide enough for that one cell, which may look unbalanced. In that case, use the dragging method instead to set a width that looks better.

Drag the Border to Set Width by Hand

Find the border between the two column headers you want to adjust. Click and hold on that border, then drag it left to make the left column narrower or right to make it wider. As you drag, you will see a dotted line showing where the new border will be. Release the mouse button when the column width looks right.

Dragging is useful when you want to balance the look of your spreadsheet or when you know roughly how wide a column should be but do not need an exact measurement. You can drag slowly for fine control, or drag quickly to move the border a large distance. If you drag too far by accident, you can undo the change by pressing Ctrl+Z (or Cmd+Z on Mac).

Right-Click to Enter an Exact Column Width

Right-click on the column header you want to resize — the letter at the top. A menu will appear. Click "Column Width" (not "Optimal Width"). A small box will open asking you to enter a width in characters. Type the number you want and click OK.

Column width in Excel is measured in the number of characters of the default font that will fit. A width of 10 means the column will hold about 10 characters across. If you are not sure what width to use, start with 15 or 20 and adjust from there. This method is most useful when you need several columns to be exactly the same width, or when you are setting up a template that other people will use.

Resize Multiple Columns at Once

To change the width of several columns to the same size, first select all the columns you want to resize. Click the header of the first column, then hold Ctrl (or Cmd on Mac) and click the headers of the other columns. They will all highlight in blue.

Once the columns are selected, use any of the three methods above. If you right-click and enter a width, all selected columns will become that width. If you drag the border of any selected column, all of them will resize together. If you double-click the border, all selected columns will auto-fit to their own content — each column will be a different width based on what it contains.

Undo a Column Width Change

If you resize a column and then change your mind, press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo the change. You can undo multiple times to go back several steps. If you have already saved the file, undo will not work — you will have to resize the column again by hand.

If you accidentally made a column very narrow and cannot see its contents, you can still resize it. Click the column header to select it, then use the right-click method to set a specific width, or double-click the border to auto-fit. You do not have to be able to see the content to resize the column.

Frequently Asked Questions

Why does my column still look too narrow after I double-clicked?

Double-click auto-fits the column to the longest entry in that column. If the longest entry is still cut off, the cell probably contains extra spaces or hidden characters. Try widening the column by hand instead, or check the cell content in the formula bar at the top to see what is actually there.

Can I set a minimum or maximum column width?

Excel does not have a built-in minimum or maximum width setting. You can set a specific width using the right-click method, but there is no way to lock a column so it cannot be made narrower or wider. If you need to prevent changes, you can protect the sheet, though that also locks cells from editing.

What is the difference between column width and optimal width?

Column width lets you enter a specific measurement. Optimal width is another name for auto-fit — it sizes the column to match its content. Some versions of Excel show "Optimal Width" as a menu option; clicking it does the same thing as double-clicking the border.

How do I make all columns the same width at once?

Select all columns by clicking the box in the top-left corner where the row numbers and column letters meet. Then right-click any column header and choose "Column Width," enter your desired width, and click OK. Every column in the sheet will become that width.

Does column width change affect the data in the cells?

No. Changing column width only changes how the data looks on screen and in print. The actual data in the cells stays the same. If a column is too narrow to display a number, Excel shows #### symbols, but the number is still there — widening the column will reveal it.