The fastest way to resize a column

To widen a column in Excel, position your cursor on the border between two column letters at the top of the spreadsheet until it turns into a resize arrow (a double-headed line), then drag left or right. Release when the column reaches the width you want. This works the same way whether you are using Excel on Windows, Mac, or the web version.

If you want to make a column exactly fit its content without guessing, double-click that same border instead of dragging. Excel automatically expands the column to fit the longest entry in it. This is called auto-fit and saves time when you have text of varying lengths.

For multiple columns at once, click the column letter of the first column you want to resize, then hold Shift and click the last column letter. Now double-click any border between the selected columns, and all of them auto-fit at the same time.

Key Takeaways

  • Double-click the border between column letters to auto-fit a single column to its content.
  • Drag the border between columns to set a custom width by hand.
  • Select multiple columns first, then double-click a border to auto-fit them all at once.
  • Right-click a column letter and choose Column Width to enter an exact measurement in characters.
  • The Format menu (on Windows) or Sheet menu (on Mac) also contains column width options if you prefer menus to dragging.

Setting an exact column width with numbers

Sometimes you need columns to be a specific width rather than whatever fits the content. Right-click the column letter, then select Column Width from the menu that appears. A box will open asking you to enter a number. This number represents character width — roughly how many average letters fit across the column.

If you are not sure what width to enter, start with 20 and adjust from there. A width of 10 is quite narrow; a width of 30 is quite wide. You can always right-click and change it again if the first number does not work for your layout.

To hide a column entirely without deleting it, right-click the column letter and choose Hide. The column still exists and any formulas that reference it still work — it just does not display. To unhide it later, select the columns on both sides of the hidden one, right-click, and choose Unhide.

Using the Format menu instead of right-clicking

On Windows, click the Format menu at the top, then look for Column and select Width. On Mac, the menu is called Sheet instead of Format, but the Column option is in the same place. This route works the same way as right-clicking — you enter a number and Excel sets the width.

The Format menu also has an Optimal Width option, which is another name for auto-fit. Use this if you prefer menus to the double-click method. Some people find it easier to remember; others find dragging faster. Both do the same thing.

Resizing columns in Excel Online

Excel Online (the version you use in a web browser) works almost the same way as the desktop version. Position your cursor on the border between column letters until it becomes a resize arrow, then drag. Double-clicking to auto-fit also works in the web version.

The right-click menu in Excel Online has fewer options than the desktop version, so if you need to set an exact width by number, use the Format menu instead. Click the column letter first to select it, then look for the column width option in the toolbar or Format menu.

What to do when a column is too narrow and shows ###

When a cell contains a number or date but the column is too narrow to display it, Excel shows ### instead of the actual value. The data is still there — it just will not fit on screen. Double-click the border between that column and the next to auto-fit, and the ### will disappear and show the real content.

This happens most often with dates and times, which take up more space than you might expect. A date like "12/15/2024" needs more room than it looks like it should. If you see ### in a column with dates, auto-fit usually solves it in one action.

Resizing all columns at once

To resize every column in your spreadsheet to fit its content, click the Select All button — the small box in the top-left corner where the row numbers and column letters meet. Then double-click any border between two column letters. All columns auto-fit at the same time.

This is useful when you paste data from another source and the columns are all the wrong width. One action fixes the entire sheet instead of adjusting each column by hand. If some columns end up too wide after this, you can always adjust individual ones afterward.

Frequently Asked Questions

Why does my column show ### instead of the number?

The column is too narrow to display the full value. Double-click the border between that column and the next one to auto-fit it. If the ### still appears, the column needs to be wider than auto-fit made it — drag the border further to the right by hand.

Can I set different widths for different columns at the same time?

No, you can only set one width at a time, or auto-fit multiple columns to their own content. If you need columns A, B, and C to be 15 characters wide and columns D and E to be 25 characters wide, adjust each group separately by selecting them and using Column Width.

Does changing column width affect the data inside?

No. Resizing a column only changes how the data looks on screen. The actual values stay the same, and any formulas that use those cells work exactly as before. You can widen or narrow columns as much as you want without losing or changing anything.

What is the difference between dragging and double-clicking the column border?

Dragging lets you set any width you want by hand. Double-clicking auto-fits the column to fit the longest entry in it. Use double-click when you want Excel to decide the width; use dragging when you want a specific width that might be wider or narrower than the content needs.