The three ways to resize a column

You can widen or narrow a column in Excel by dragging its edge, double-clicking to fit the content, or typing a specific width. The fastest method depends on what you're trying to do: drag when you want to eyeball it, double-click when text is cut off and you want it to fit automatically, and type a number when you need exact widths across multiple columns.

All three methods work the same way in Excel for Windows, Excel for Mac, and Excel Online. The column header is the gray box at the top that shows the letter (A, B, C, and so on). The edge between two column headers is where you'll position your cursor to resize.

Key Takeaways

  • Drag the border between two column headers left or right to resize the column on the left side of that border.
  • Double-click the border between two column headers to automatically fit the column width to whatever text or numbers it contains.
  • Right-click a column header and select Column Width to type an exact measurement if you need columns to be the same size.
  • Select multiple column headers at once and resize them together so they all become the same width.

Dragging the column edge to resize

Position your cursor on the line between two column headers until it changes to a resize cursor — it looks like a double-headed arrow pointing left and right. Click and hold, then drag left to make the column narrower or right to make it wider. Release the mouse button when the column is the width you want.

This method is the fastest when you're adjusting one or two columns and you don't need an exact measurement. You can see the change happen in real time as you drag, so you can stop when it looks right. If you drag too far, just drag back.

Double-clicking to fit content automatically

Position your cursor on the line between two column headers until it becomes a resize cursor. Double-click. Excel measures the longest entry in that column and widens or narrows it so everything fits without being cut off.

This is the best choice when a column contains text that's been cut short and you want to see all of it at once. It's also useful when you've pasted data and don't know how wide the columns need to be. Double-click the border between each column header, and Excel adjusts them all to fit their content.

Typing an exact column width

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

This method is useful when you need multiple columns to be exactly the same width, or when you're recreating a spreadsheet that has a specific layout. If you want to return a column to its default width, right-click and select Optimal Width instead, which does the same thing as double-clicking the border.

Resizing multiple columns at the same time

Click the first column header you want to resize, then hold Ctrl (Windows) or Command (Mac) and click each additional column header. All the selected columns will highlight in blue. Now drag the border of any selected column, and all of them resize together to the same width.

Alternatively, select the columns by clicking the first header, holding Shift, and clicking the last header in the range. This selects all columns between them. Then drag any border or right-click and choose Column Width to set them all at once.

When a column is too narrow to display numbers

If a cell shows ### instead of a number, the column is too narrow. Double-click the border between that column header and the next one, and Excel widens it enough to show the full number. If you see ### in a date or time cell, the same fix applies.

Text that's too long for the column will spill into the next cell if that cell is empty, but numbers and dates always show as ### when there's no room. Widening the column is the only way to see what's actually there.

Hiding and unhiding columns

If you want to remove a column from view without deleting it, right-click the column header and select Hide. The column disappears, but the data stays in the file. To bring it back, select the columns on either side of the hidden one, right-click, and select Unhide.

Hiding is different from making a column very narrow — the column is completely removed from view, and the next column slides over to take its place. This is useful when you have data you need to keep but don't want to see while you're working on something else.

Frequently Asked Questions

Why does my column width keep changing when I paste data?

Excel doesn't automatically resize columns when you paste. If a column looks different after pasting, you probably pasted data that's wider than what was there before. Double-click the column border to fit it to the new content, or drag it to the width you want.

Can I set a minimum or maximum column width?

Excel doesn't have a built-in minimum or maximum, but you can manually set any width you want by right-clicking the column header and selecting Column Width. If you need columns to stay a certain size, set them and then protect the sheet so others can't change them.

What's the difference between Column Width and Optimal Width?

Column Width lets you type an exact number. Optimal Width (or double-clicking the border) automatically measures the longest entry in the column and fits it. Use Optimal Width when you want Excel to decide, and 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 any column header and select Column Width. Type the width you want, and all columns become that size.