The fastest way to change column width

Double-click the line between two column letters at the top of your spreadsheet. Excel automatically fits the column to the width of whatever text or numbers are inside it. This works for one column at a time.

If you want to set an exact width instead, right-click the column letter, select Column Width, and type a number. The default width is about 8.43 characters, so typing 15 would make it roughly twice as wide.

To change multiple columns at once, click the first column letter, hold Shift, and click the last column letter you want to resize. Then double-click the border between any two of those column headers, and all selected columns will auto-fit together.

Key Takeaways

  • Double-click the border between column letters to auto-fit a single column to its content.
  • Right-click a column letter and choose Column Width to set an exact width by typing a number.
  • Select multiple columns by clicking the first, holding Shift, and clicking the last, then double-click any border between them to auto-fit all at once.
  • Drag the border between column letters left or right to resize by eye without using menus.
  • The Format menu also contains column width options if you prefer working through the ribbon instead of right-clicking.

Dragging the column border by hand

Position your cursor on the line between two column letters at the very top of the spreadsheet until it changes to a resize cursor (a double-headed arrow). Then click and drag left to make the column narrower or right to make it wider. Release when it reaches the size you want.

This method gives you the most control if you want a specific look but do not need an exact measurement. It is faster than opening a menu, but less precise than typing a number.

Using the Format menu for column width

Click the Format menu in the ribbon, then look for the column options. In newer versions of Excel, you will see Column Width and Optimal Width (which is the same as double-clicking the border). In older versions, the menu may say Column instead of Format.

The Format menu is useful if you are already working in the ribbon and want to avoid right-clicking. It also shows you options like Hide and Unhide columns in the same place, which can be helpful if you need to organize your spreadsheet.

What "optimal width" means and when to use it

Optimal width (also called auto-fit) measures the longest piece of text or the widest number in that column and makes the column just wide enough to show all of it without wrapping. This is what happens when you double-click the column border.

Use optimal width when you want all your data visible at a glance and do not care about exact spacing. It works well for spreadsheets you are building for yourself. If you are sharing a spreadsheet with others or printing it, you might want to set widths by hand so the layout stays consistent no matter what data someone adds later.

Resizing all columns at once

Click the box in the top-left corner of the spreadsheet (the intersection of the row numbers and column letters) to select every cell. Then double-click any border between two column letters, and all columns will auto-fit to their content at once.

This is a quick way to clean up a messy spreadsheet where some columns are too narrow and some are too wide. Be aware that if one column has a very long entry, it will become very wide, which might push your spreadsheet off the screen.

Setting a minimum or maximum width

Excel does not have a built-in way to set a minimum width that prevents a column from getting too narrow, but you can work around this by typing a specific width number. Right-click the column, select Column Width, and enter the smallest width you want to allow.

If you want to prevent someone from accidentally making a column too wide, the same method works in reverse — just set the width to a number that feels right for your data. There is no maximum width setting, but columns can be as wide as your screen allows.

Frequently Asked Questions

Why does my column still show ### symbols after I make it wider?

The ### symbols mean the column is still not wide enough for the number or date inside. Make it wider by dragging the border further to the right, or double-click the border to auto-fit. If you see ### in a date column, dates usually need more space than you might expect.

Can I set different widths for the same column on different sheets?

Yes. Each sheet in your workbook has its own column widths. Changing the width on one sheet does not affect the others. If you want the same width across multiple sheets, you have to set it on each sheet separately.

What is the difference between column width and optimal width?

Column width is the exact measurement you set yourself by typing a number or dragging. Optimal width is what Excel calculates automatically based on the longest content in that column. Optimal width changes if you add longer text later, but a width you set by hand stays the same.

How do I make a column narrower without losing data?

Making a column narrower does not delete data — it just hides it from view. The data is still there. If you see ### symbols, the column is too narrow to display the content. Widen it again to see the data, or edit the cell to make the entry shorter.