The three ways to resize a column

You can change column width in Excel by dragging the column border, double-clicking to auto-fit, or typing a specific width measurement. The method you choose depends on whether you want to eyeball the width, make all content fit automatically, or set an exact size.

All three methods work the same way across Excel versions on Windows and Mac. The column you resize affects only that single column unless you select multiple columns first — then your change applies to all of them at once.

Key Takeaways

  • Drag the border between two column letters at the top to resize; position your cursor until it turns into a resize arrow, then drag left or right.
  • Double-click the border between column letters to auto-fit the column width to whatever content is inside it.
  • Right-click a column letter and select Column Width to type an exact measurement in inches or centimeters.
  • Select multiple columns by clicking the first, holding Shift, and clicking the last — then resize all of them together.
  • The column header row (where letters A, B, C appear) is where you grab the border; dragging inside the cells themselves does not work.

Dragging the column border to resize

Position your cursor on the line between two column letters at the very top of the spreadsheet. The cursor will change to a resize arrow — a double-headed line pointing left and right. This tells you that you are in the right spot to drag.

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

If you drag too far and the column becomes very narrow, you may see a small red triangle or the text "###" inside the cells. This means the content is too wide to display. Drag the border right again to widen the column until the content shows.

Double-clicking to auto-fit column width

Double-click the border between two column letters at the top. Excel automatically widens or narrows the column to fit the longest piece of content in that column. This is the fastest way to make sure all your text and numbers are visible without manual adjustment.

Auto-fit looks at every cell in the column, including headers. If one cell contains a very long entry, the entire column expands to show it. If you later add longer text to that column, you will need to auto-fit again.

Setting an exact column width

Right-click on the column letter you want to resize. A menu will appear. Click Column Width (not "Optimal Width" — that is a different option). A small box will pop up asking you to enter a width number.

Type the width you want. Excel measures column width in character units by default — the number represents how many characters of average width fit in the column. You can also type a measurement like "2 inches" or "5 cm" and Excel will convert it automatically.

Click OK. The column adjusts to exactly the width you entered. This method is useful when you need columns to be a specific size for printing or to match a template.

Resizing multiple columns at once

Click on the first column letter you want to resize. Hold down the Shift key and click on the last column letter in the range. All columns between them will be highlighted in blue. Now drag the border of any highlighted column, and all selected columns will resize together to the same width.

You can also select multiple columns by clicking the first one, then holding Shift and clicking the last. Then right-click and choose Column Width to set all of them to the exact same measurement at once.

Undoing a resize if you make a mistake

Press Ctrl+Z on Windows or Command+Z on Mac when ready after resizing. Excel will undo the change and return the column to its previous width. You can undo multiple times to go back several steps if needed.

If you have already closed the file or performed other actions since the resize, undo may not work. In that case, you can always resize the column again using any of the methods above.

Common mistakes to avoid

The most common mistake is trying to drag inside a cell instead of on the column border. If you click inside a cell and drag, you will select multiple cells instead of resizing. Make sure your cursor is positioned on the thin line between two column letters at the very top of the spreadsheet.

Another mistake is not noticing when content is hidden. If a column is very narrow and shows "###" or nothing at all, widen it by dragging or double-clicking the border. Text does not disappear — it is just too wide to display in that space.

When setting an exact width, remember that Excel uses character units by default. If you want a column to be exactly 1 inch wide, type "1 inch" or "2.54 cm" rather than just a number. Without a unit, Excel assumes you mean character width.

Frequently Asked Questions

Why does my column show ### instead of numbers?

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 widen it manually. This usually happens with dates, times, or long numbers.

Can I set a minimum or maximum column width?

Excel does not have built-in minimum or maximum width settings. You can manually resize columns as needed, but there is no lock to prevent them from being resized smaller or larger. You can document a standard width in a template file and resize columns to match it each time.

Does resizing a column affect the data inside it?

No. Resizing a column only changes how the data is displayed on screen and in print. The actual data stays the same. If you widen a column and then narrow it again, all the original content remains intact.

What is the difference between Column Width and Optimal Width?

Column Width lets you type an exact measurement. Optimal Width is Excel's auto-fit feature — it automatically sizes the column to fit the longest content. Use Optimal Width for speed; use Column Width when you need a specific size.

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 and choose Column Width, or drag any column border. All columns will resize to the same width.