The Three Ways to Resize a Column

You can change a column's width in Excel by double-clicking the border between column headers, dragging that border to a new width, or typing a specific measurement. The double-click method fits the column to whatever text is inside it. Dragging gives you manual control. Typing a number lets you set an exact width down to the decimal point.

All three methods work the same way in Excel for Windows and Excel for Mac. The steps are identical whether you're using Excel 2019, Excel 2021, or Microsoft 365. If you're using Google Sheets or another spreadsheet program, the process is slightly different, but the concept is the same.

Key Takeaways

  • Double-click the border between two column headers to auto-fit the column width to the text inside it.
  • Drag the border between column headers left or right to manually set the width to whatever size you want.
  • Right-click a column header and select "Column Width" to type in an exact measurement.
  • You can resize multiple columns at once by selecting them first, then using any of these three methods.
  • The default column width in Excel is 8.43 characters, but you can change this for new sheets in your workbook settings.

Auto-Fit a Column by Double-Clicking

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 column to fit the longest text in that column.

This method is the fastest when you just want the column to show all its content without cutting off text. If a cell contains a long sentence and the column is too narrow, double-clicking the border will expand the column just enough to show the full sentence on one line. If the column is wider than it needs to be, double-clicking will shrink it.

One thing to watch: if a cell contains a formula that returns a very long result, or if you have a header that is much longer than the data below it, auto-fit will size the column to fit that one cell. You may end up with a column that is wider than you want.

Drag the Column Border to Set Width Manually

Click and hold on the border between two column headers. Drag it to the left to make the column narrower, or to the right to make it wider. Release the mouse button when the column reaches the width you want. This method gives you complete control and takes only a second or two.

As you drag, you'll see a dotted line showing where the new border will be. This preview helps you judge the width before you release. If you drag too far and the column becomes too narrow, you can when ready drag the border again to adjust it.

Dragging works best when you can see the result you want on screen. If you need to set the width to a specific measurement — say, exactly 2 inches — dragging is less precise than typing the number.

Type an Exact Column Width

Right-click on the column header you want to resize. A menu will appear. Click on "Column Width" (not "Optimal Width" — that's the auto-fit option). A dialog box will open with a text field showing the current width as a number.

Clear the number and type the width you want. Excel measures column width in character units, not inches or centimeters. The default width is 8.43 characters. If you type 15, the column will be about 15 characters wide. Type your number and click OK.

This method is useful when you need columns to be consistent across multiple sheets, or when you're working from a template that specifies exact widths. You can also use this to make a column very narrow — type 1 or 2 to create a thin column, or type 0.5 to make it almost invisible (useful for hiding data you don't want to delete).

Resize Multiple Columns at Once

Click on the first column header you want to resize. Hold Ctrl (or Cmd on Mac) and click on each additional column header. All selected columns will be highlighted in blue. Now use any of the three methods above — double-click a border to auto-fit all of them, drag a border to resize all of them together, or right-click and type a width to set them all to the same size.

This is much faster than resizing columns one at a time, especially if you have a spreadsheet with many columns that need adjustment. When you drag the border of any selected column, all selected columns will resize by the same amount.

If you want to resize all columns in the sheet at once, click the select-all button — the small box in the top-left corner where the row numbers and column letters meet. Then use any resize method. This is helpful when you're starting a new sheet and want to set a consistent width for all columns from the beginning.

Common Mistakes to Avoid

The most common mistake is dragging the wrong border. Make sure your cursor is exactly on the line between two column headers, not in the middle of a header. If you click in the middle of a column header, you'll select the column instead of resizing it. Move your cursor to the right edge of the column header you want to resize.

Another mistake is confusing "Column Width" with "Optimal Width" in the right-click menu. "Optimal Width" is the auto-fit option and will resize the column automatically. "Column Width" is where you type a specific number. If you want to type a measurement, make sure you click on "Column Width."

If you resize a column and the text still appears cut off, the column may not be wide enough yet, or the text may be rotated or formatted in a way that takes up more space. Try widening it more, or check the cell's alignment and text rotation settings.

Frequently Asked Questions

What is the difference between column width and optimal width?

Column Width lets you type a specific measurement. Optimal Width (also called auto-fit) automatically sizes the column to fit the longest text in that column. Use Optimal Width when you want Excel to decide the size, and Column Width when you want to set it yourself.

Can I set a minimum or maximum column width?

Excel does not have a built-in minimum or maximum width setting. However, you can manually set a width and then protect the sheet to prevent others from changing it. Go to Format > Protect Sheet to lock column widths in place.

Why does my column width keep changing when I type?

If you have auto-fit turned on for that column, Excel may resize it automatically when you enter or edit text. To stop this, turn off auto-fit by going to Format > Column > Optimal Width and toggling it off, or straightforward set a fixed width using the Column Width option.

How do I make all columns the same width?

Select all columns by clicking the select-all button in the top-left corner. Right-click and choose "Column Width," then type the width you want. All columns in the sheet will be set to that width. You can also select just the columns you want to match before doing this.

Can I resize a column by dragging on a Mac?

Yes, the dragging method works exactly the same on Mac. Position your cursor on the border between column headers until it changes to a resize arrow, then click and drag left or right. All three methods — double-click, drag, and typing a width — work on both Windows and Mac versions of Excel.