The three ways to resize a column

You can change column width in Excel by dragging the border between column headers, by double-clicking to auto-fit, or by typing a specific width in the Format menu. The drag method is fastest for one or two columns. Auto-fit works when you want the column to match its content automatically. The Format menu gives you exact control when you need columns to be a precise width across a spreadsheet.

All three methods work the same way whether you use Excel on Windows, Mac, or the web version. The steps are identical in Excel 2016, 2019, 2021, and Microsoft 365.

Key Takeaways

  • Drag the border between two column headers left or right to resize the column on the left; this is the fastest method for single columns.
  • Double-click the border between column headers to auto-fit the column width to whatever text or numbers it contains.
  • Right-click a column header, select Format Cells, and enter a specific width in inches or centimeters for precise control.
  • Select multiple columns first if you want to change the width of several columns at once using any of these methods.

Dragging the column border to resize

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 arrow pointing left and right). Click and drag the border 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.

This method changes only the column on the left side of the border you dragged. If you drag the border between columns B and C, you are resizing column B. The column on the right stays in place.

Auto-fitting a column to its content

Double-click the border between two column headers. Excel automatically widens or narrows the column on the left to fit the longest entry in that column. This is useful when you have text or numbers that are cut off, or when you want to remove extra empty space.

If a column contains a long heading but short data below it, auto-fit will make the column wide enough for the heading. If the data below is longer than the heading, auto-fit will make the column wide enough for the data instead.

Setting an exact column width through the Format menu

Right-click the column header you want to resize. A menu will appear. Click Format Cells (or Column Width if that option appears directly). A dialog box will open. Type the width you want in the text field. Excel measures column width in character units by default, but you can also type a measurement in inches or centimeters if you specify the unit.

For example, type 2 for 2 character units, or 1.5 inches for 1.5 inches. Click OK or press Enter. The column will resize to exactly the width you entered. This method is most useful when you need multiple columns to be the same width, or when you are formatting a spreadsheet that will be printed.

Resizing multiple columns at once

Click the header of the first column you want to resize. Hold Ctrl (or Cmd on Mac) and click the headers of the other columns. All selected columns will highlight in blue. Now use any of the three methods above — drag, double-click, or use the Format menu — and the change will explore to all selected columns at once.

If you want to resize all columns in the spreadsheet, click the select-all button (the box in the top-left corner where the row numbers and column letters meet). Then drag any column border, double-click any border, or use the Format menu. Every column will resize together.

Undoing a column width change

If you resize a column and then change your mind, press Ctrl+Z (or Cmd+Z on Mac) when ready. Excel will undo the resize and return the column to its previous width. You can undo multiple times to step back through several changes.

If you have already saved the file after resizing, undo will not work. In that case, you will need to resize the column again manually or reload the file from before you saved it.

Frequently Asked Questions

Why can't I drag the column border?

Your cursor must be exactly on the line between two column headers for the resize arrow to appear. If you click slightly to the left or right of the line, you will select the column instead. Move your cursor slowly along the border between the headers until you see the double-headed arrow, then drag.

What is the difference between column width and column size?

In Excel, these terms mean the same thing. Column width is the measurement of how wide a column is. There is no separate "column size" setting. When someone says to change the column size, they mean to change the column width.

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 any width you want through the Format menu, but there is no way to lock a column so it cannot be made narrower or wider than a certain size. You would need to use a macro or a third-party tool for that.

Does changing column width 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 text is hidden because the column is too narrow, it is still there — it just is not visible until you widen the column.

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 any column header and choose Format Cells or Column Width. Type the width you want and click OK. All columns will become that width. Alternatively, select the columns you want to match, then drag the border of any selected column header to resize them all together.