The Three Ways to Resize a Column

You can change column width in Excel by dragging the border between column headers, double-clicking to auto-fit the content, or typing a specific width measurement. The method you choose depends on whether you want to fit text exactly, make all columns the same width, or set a precise measurement for printing or formatting.

All three methods work the same way in Excel for Windows and Excel for Mac. If you are using Excel Online in a web browser, the drag method works, but the auto-fit and manual entry options are slightly different — we cover those separately below.

Key Takeaways

  • Drag the border between two column headers left or right to resize the column on the left; the cursor changes to a resize arrow when you are in the right spot.
  • Double-click the border between column headers to auto-fit the width to whatever text is in that column, which saves time when you have long entries.
  • Right-click a column header and select Column Width to type an exact width in inches or centimeters, useful for consistent formatting across sheets.
  • Select multiple columns by clicking the first header, holding Shift, and clicking the last header, then resize them all at once to the same width.
  • In Excel Online, use the Format menu instead of right-clicking, since the context menu has fewer options.

Dragging the Column Border to Resize

Position your cursor on the line between two column headers at the top of the spreadsheet. The cursor should change to a resize arrow — a double-headed line pointing left and right. If you see a regular arrow instead, move slightly left or right until the resize cursor appears.

Click and hold the border, then drag it 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 on the left of the border is the one that changes; the column on the right stays in place.

This method is fastest for quick adjustments, but it relies on your eye to judge the width. If you need the same width across multiple columns, use the manual entry method instead.

Auto-Fitting Column Width to Content

Double-click the border between two column headers to automatically adjust the left column to fit all the text inside it. Excel measures the longest entry in that column and widens or narrows the column to match. This is much faster than dragging when you have many columns or long text entries.

If a column contains a header that is longer than the data below it, auto-fit will make the column wide enough for the header. If the data is longer than the header, it will fit the data instead. The column adjusts to whichever is longest.

To auto-fit all columns at once, click the select-all button (the small square in the top-left corner where the row numbers and column letters meet), then double-click any column border. Every column will resize to fit its content.

Setting an Exact Column Width

Right-click the column header you want to resize and select Column Width from the menu. A dialog box will open with a text field showing the current width. Type the width you want — the default unit is inches, but you can type a number followed by "cm" for centimeters.

For example, type 1.5 for 1.5 inches, or 3cm for 3 centimeters. Click OK and the column will resize to exactly that width. This method is useful when you need consistent column widths across multiple sheets or when you are formatting a spreadsheet for printing.

If you want to set the same width for several columns, select all of them first. Click the first column header, hold Shift, and click the last column header in the range you want. Then right-click and choose Column Width. All selected columns will resize to the same width.

Resizing Columns in Excel Online

In Excel Online, you can drag column borders the same way as in the desktop version. Position your cursor on the line between two column headers, wait for the resize cursor to appear, then drag left or right.

To set an exact width in Excel Online, click the column header to select it, then click the Format menu at the top. Select Column, then Column Width. Type the width you want and click OK. Auto-fit is not available in Excel Online through the right-click menu, but dragging works just as well for most tasks.

Undoing a Column Resize

If you resize a column and change your mind, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo the change. This works whether you dragged, auto-fit, or typed a width manually.

If you have already made other changes since resizing the column, undo will reverse all of them, not just the column width. In that case, you can resize the column again by hand or use the Column Width dialog to set it back to the original width if you remember what it was.

Common Mistakes to Avoid

The most common mistake is clicking in the middle of a column header instead of on the border between two headers. If you click the header itself, you select the entire column instead of resizing it. Move your cursor to the right edge of the column header you want to resize, where it meets the next column.

Another mistake is dragging too far and making a column so narrow that the text is hidden. If this happens, double-click the border to auto-fit, or drag it wider again. You can also select the column and use Column Width to set a specific width if you are not sure how wide it should be.

In Excel Online, trying to right-click for a context menu sometimes does not work on a column header. Use the Format menu at the top instead — it has all the same options.

Frequently Asked Questions

How do I make all columns the same width at once?

Select all columns by clicking the select-all button in the top-left corner, then right-click any column header and choose Column Width. Type the width you want and click OK. All columns will resize to that width. You can also select just the columns you want by clicking the first header, holding Shift, and clicking the last one.

What is the default column width in Excel?

The default column width is 8.43 characters, which is about 1 inch on most screens. This width is designed to fit a typical number or short word. If you change the default width, it only affects new columns you create — existing columns keep their current width unless you resize them.

Can I hide a column instead of making it narrower?

Yes. Right-click the column header and select Hide. The column will disappear from view but the data stays in the file. To unhide it, select the columns on either side of the hidden one, right-click, and choose Unhide. This is useful when you want to keep data but do not need to see it right now.

Why does my text still not fit after I resize the column?

If text is still cut off, the column may not be wide enough, or the text may be too long to fit on one line. Try double-clicking the column border to auto-fit, or manually drag it wider. You can also turn on text wrapping — select the column, go to the Home tab, click Wrap Text, and the text will break into multiple lines within the cell instead of being cut off.

Does resizing a column change the data inside it?

No. Resizing a column only changes how the data looks on screen or in print. The actual data in the cells stays the same. If you make a column so narrow that text is hidden, the text is still there — it just is not visible until you widen the column again.