The three ways to change column width in Excel
You can adjust column width in Excel by dragging the border between column headers, by double-clicking to auto-fit, or by typing a specific width in the Format menu. The method you choose depends on whether you want to resize one column, multiple columns at once, or fit content automatically.
All three methods work the same way in Excel for Windows, Excel for Mac, and Excel Online. The keyboard shortcuts differ slightly between Windows and Mac, but the menu options work identically.
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're in the right spot.
- Double-click the border between column headers to automatically fit the column width to whatever content is inside it.
- Select multiple columns and drag one border to resize all of them at once to the same width.
- Right-click any column header and choose Column Width to type in an exact measurement if you need precise sizing.
Dragging the column border to resize manually
Position your cursor on the line between two column headers at the top of your spreadsheet. The cursor should change to a resize arrow — a double-headed arrow pointing left and right. Click and drag that border to the left to make the column narrower, or to the right to make it wider.
Release the mouse 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. If you drag too far and can't see where you are, you can undo the change by pressing Ctrl+Z on Windows or Command+Z on Mac.
Double-clicking to auto-fit column width
Double-click the border between two column headers, and Excel automatically adjusts the left column to fit all the content inside it. This is the fastest way to make a column just wide enough to show everything without extra empty space.
If a cell contains a long formula or a wrapped paragraph of text, auto-fit sizes the column to show the widest single line. If you have a cell with text that wraps across multiple lines, auto-fit makes the column wide enough for that text, but it does not automatically make the row taller — you may need to adjust row height separately.
Resizing multiple columns at the same time
Click on the header of the first column you want to resize, then hold Shift and click on the last column in the range. All columns between them are now selected (they appear highlighted). Now drag the border between any two of the selected column headers, and all selected columns resize to the same width.
You can also select all columns in your spreadsheet by clicking the box in the top-left corner where the row numbers and column letters meet. Then drag any column border to resize every column at once. This is useful if you want a uniform width across your entire sheet.
Typing an exact column width in the Format menu
Right-click on any column header and select Column Width from the menu. A dialog box appears where you can type a number. Excel measures column width in character units — the number represents how many characters of the default font can fit across the column.
If you want even more control, you can also right-click and choose Optimal Width, which auto-fits the column the same way double-clicking does. Some versions of Excel also offer Hide and Unhide options in this menu if you need to temporarily remove a column from view.
What to do if a column is too narrow and shows hash marks or truncated text
When a column is too narrow to display a number, Excel shows a series of hash marks (###) instead. When text is too long, Excel either truncates it (cuts it off) or hides it, depending on whether the next cell is empty. Neither means your data is lost — it's just not visible at that width.
Double-click the column border to auto-fit, or drag it wider until the content appears. If you see ### in a column of numbers, the column needs to be wider than if it contained text, because numbers take up more space in most fonts.
Resizing columns in Excel Online versus desktop Excel
Excel Online works the same way as desktop Excel for basic column resizing — you can drag borders and double-click to auto-fit. However, Excel Online does not have a Column Width dialog box. If you need to set an exact width, you must use the desktop version of Excel.
Excel Online also sometimes has slight delays when you drag a column border, especially on slower internet connections. If dragging feels sluggish, try double-clicking to auto-fit instead, which usually responds faster.
Frequently Asked Questions
Why does my column still show ### after I make it wider?
The column may not be wide enough yet, or the cell may contain a formula error. Try double-clicking the column border to auto-fit, which sizes it to the actual content. If you still see ###, the column width is at its maximum for that data type, and you may need to check the cell content itself.
Can I set different widths for the same column in different parts of my spreadsheet?
No. Column width applies to the entire column from top to bottom. If you need different widths for different sections, you would need to insert a new column or reorganize your data. You can hide columns you don't need to see, which is faster than deleting them.
Does adjusting column width change the font size or the actual data?
No. Column width only changes how much space is available to display the data. The font size and the data itself stay the same. If you want to make text larger or smaller, you need to change the font size separately through the Format menu or toolbar.
What's the difference between column width and optimal width?
Column width lets you type any number you want for precise control. Optimal width automatically calculates the smallest width needed to show all content in that column without truncation. Optimal width is faster if you just want things to fit; column width is better when you need exact sizing for alignment or printing.