The three ways to resize a column

You can change how wide a column is in three ways: by double-clicking the border between column headers to fit the content automatically, by dragging that border to a width you choose, or by right-clicking the column header and typing an exact measurement. Which one you use depends on whether you want Excel to decide the width or you want to set it yourself.

All three methods work the same way regardless of whether you are using Excel on Windows, Mac, or the web version. The column you resize stays that width until you change it again — it does not reset when you save or close the file.

Key Takeaways

  • Double-click the line between two column headers to make that column fit its content automatically, which is the fastest method for most work.
  • Drag the border between column headers to the right or left to set a column width by eye, useful when you want columns to look balanced rather than tight.
  • Right-click a column header, select Column Width, and type a number to set an exact width in character units, which is the only way to match columns across different sheets.
  • Select multiple columns at once before resizing to change them all to the same width in one action.
  • The width you set stays in place when you save, close, or share the file with someone else.

Double-clicking to fit content automatically

The fastest way to resize a column is to position your cursor on the line between two column headers at the top of the spreadsheet. The cursor will change to a resize arrow — two lines with arrows pointing left and right. Double-click at that spot, and Excel will widen or narrow the column to fit whatever text or numbers are in it.

This method works best when your data is clean and you do not have extra spaces or very long notes in a single cell. If one cell contains a paragraph and the rest of the column is short, double-clicking will make the column very wide to fit that one cell. In that case, you may want to drag the border instead to set a width that works for most of your data.

Dragging the column border to set width by eye

Position your cursor on the line between two column headers until you see the resize arrow. 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 looks the way you want it. This method gives you full control and is useful when you want columns to look balanced on the page rather than squeezed tight around the text.

Dragging is also the best choice when you have a mix of short and long entries in a column and want to set a middle ground. You can always drag again later if you change your mind about the width.

Right-clicking to set an exact width

Right-click on any column header — the letter at the top — and select Column Width from the menu. A small box will appear asking you to enter a number. Type the width you want (measured in character units, where 1 unit is roughly the width of one letter in the default font) and click OK.

This method is the only way to set columns to an exact, matching width across different sheets in the same workbook. It is also useful if you are building a spreadsheet that someone else will use and you want the columns to look the same every time they open it. If you are not sure what number to use, start with 15 or 20 and adjust from there.

Resizing multiple columns at once

Click on the first column header you want to resize, then hold Shift and click on the last column header in the range. All columns between them will be highlighted in blue. Now use any of the three methods above — double-click the border, drag it, or right-click and enter a width — and all selected columns will resize together.

This is much faster than resizing columns one at a time, especially if you have a spreadsheet with many columns that should all be the same width. You can also select every column in the sheet by clicking the box in the top-left corner where the row numbers and column letters meet, then resize them all at once.

What happens to column width when you save or share

The column widths you set are saved as part of the file. When you save the spreadsheet and open it again, the columns will be exactly as wide as you left them. If you share the file with someone else, they will see the same column widths on their screen.

The only exception is if someone else opens the file and changes the column widths themselves — their changes will save over yours the next time they save the file. Column width is not locked by default, so anyone with edit access can resize columns.

Undoing a column resize you did not mean to make

If you resize a column and when ready realize you made a mistake, press Ctrl+Z (Windows) or Command+Z (Mac) to undo the change. This works even if you resized multiple columns at once. You can undo several steps in a row if you need to go back further.

If you closed the file and reopened it, you cannot undo the resize — the width is now saved. In that case, you will need to resize the column again to fix it.

Frequently Asked Questions

Can I make a column so narrow that the text disappears?

Yes. If you drag a column border all the way to the left, the column becomes hidden — the text is still there, but you cannot see it. To unhide it, click between the two column headers where the hidden column is, drag to the right, and the column will reappear. You can also right-click the column headers on either side of the hidden column and select Unhide.

What is the difference between column width and column height?

Column width controls how far left to right a column stretches. Row height controls how far up and down a row stretches. You resize row height by dragging the line between row numbers on the left side of the spreadsheet, using the same double-click or drag method as columns.

Does changing column width affect the data inside the cells?

No. Resizing a column only changes how the data looks on screen. The actual numbers, text, and formulas stay exactly the same. If a cell contains a long number or word and the column is too narrow to display it all, Excel shows a series of pound signs (####) or cuts off the text, but the full content is still there.

Can I set a minimum or maximum column width?

Excel does not have a built-in minimum or maximum width setting. You can resize any column to any width you want, from very narrow to very wide. If you want columns to stay a certain width, you can protect the sheet, but that also locks cells from being edited unless you unprotect it first.