To adjust column width in Excel, select the column, go to Home > Cells > Format > Column Width, and type a value from 0 to 255 characters; or double-click the right edge of the column header to AutoFit it to its contents. The default width is 8.43 characters, and a column too narrow for a number shows #### instead of the value.

A column that is too narrow hides numbers behind #### symbols. A column that is too wide pushes data off the screen. Both problems are everyday annoyances, and both have the same fix: adjust the column width. Excel gives you several ways to do it: dragging, AutoFit, the ribbon, keyboard access keys, and VBA.

This guide walks through every method that actually works, from the obvious drag-and-drop to the AutoFit double-click trick, ribbon menus, keyboard shortcuts, and a VBA snippet for power users. You will also find fixes for the common gotchas — columns that refuse to resize, hidden columns that look stuck at zero, and how column width and row height use different units.

Why column width matters more than you think

When you type a number that does not fit, Excel shows #### instead of the value. The number is still there — Excel just refuses to truncate it, because that could mislead you about the actual figure. Text, on the other hand, spills into the next column if that cell is empty, then gets cut off the moment a neighbor has content. So a quick width adjustment is the difference between a spreadsheet that reads cleanly and one that hides half its data.

Column width in Excel is measured in characters of the default font, not pixels or inches. A width of 8.43 means the cell fits about 8.43 characters of the default font. Because the unit is tied to the default font, changing that font changes how wide a given number looks.

Excel column width and row height: reference values

Source: Microsoft Support, "Change the column width or row height in Excel" and "Excel specifications and limits".

Method 1: drag the column border

This is the method everyone learns first, and it is fine for one-off tweaks. Move your cursor to the right border of the column header — the gray strip with the letters A, B, C. The cursor changes into a vertical line with arrows on both sides. Hold the left mouse button and drag right to make the column wider, left to make it narrower. As you drag, Excel shows a tooltip with the current width, so you can stop at a precise value.

Drag does not give you a way to be exact, though. If you need column B to be exactly 20 characters wide because that matches a template, you are guessing. For one column it might not matter; for a 50-column report it will. That is where the ribbon dialog and the keyboard shortcut come in.

Method 2: double-click for AutoFit

Hover the same right border, but instead of dragging, double-click. Excel snaps the column to the width of the longest visible cell. This is AutoFit, and it is the single fastest way to make a messy spreadsheet readable. To AutoFit several columns at once, select them first by clicking and dragging across the column letters, then double-click any selected border.

AutoFit looks at the data that is actually in the column at that moment. Add a longer entry later and the column stays the same — you would need to AutoFit again. The full method, is covered in the dedicated AutoFit Excel guide.

Method 3: set an exact width through the ribbon

When you need columns to be exactly the same width — for a printable report, a dashboard, or a shared template — the ribbon dialog is the right tool. Select the columns, click the Home tab, find the Cells group, click Format, then click Column Width under Cell Size. A small dialog appears asking for a number. Type the value, click OK, and Excel applies it to every column in the selection.

The number you type is in characters of the default font, not pixels or inches. To set the width for the whole sheet at once, click Select All (the triangle at the top-left corner of the worksheet, between the column A header and the row 1 header), then run the same Format > Column Width command.

Method 4: keyboard shortcuts that save real time

If you spend hours in spreadsheets, keyboard shortcuts are the single biggest win. On Windows, press Alt to show ribbon Key Tips, then H for the Home tab, and follow the on-screen letters for Format; the sequence is commonly Alt, H, O, W for Column Width and Alt, H, O, I for AutoFit Column Width. Press the keys in sequence, not together. Excel highlights the available keys as you go. Microsoft lists Ctrl+0 to hide the selected columns; to unhide, select the columns on either side, right-click, and choose Unhide.

None of those involve the mouse at all. Combined with arrow-key navigation and Ctrl+Space (select the active column), you can resize, reformat, and rearrange a whole report without lifting your hands. For a complete reference, the Excel Shortcuts roundup covers more keys for Windows and Mac.

Method 5: VBA for templates and automation

If you build the same report every month, manual resizing wastes time. A short VBA macro fixes the widths in one line. Open the Visual Basic Editor with Alt+F11, insert a module, and paste a snippet like Columns("A:E").ColumnWidth = 15. Run it and columns A through E all become 15 characters wide. To AutoFit instead, use Columns("A:E").AutoFit.

Macros live with the workbook (save as .xlsm) or in your Personal Macro Workbook for use across every file. Before VBA will run, you usually need to enable macros — see the Enable Macros in Excel guide for the security settings.

Common problems when columns refuse to resize

Sometimes a column ignores every method above. A common cause is a protected worksheet. Go to Review > Unprotect Sheet, enter the password if there is one, and try again.

Another sneaky cause: hidden columns. A column with width 0 still occupies a letter, so you might think the column you want is C when it is actually D and C is hidden flush. Select the columns around it, right-click, and choose Unhide. The full procedure is in How to Unhide All Rows in Excel — the same idea applies to columns.

Width versus row height — they work differently

Row height behaves almost identically: drag a row border, double-click for AutoFit, or use Home > Format > Row Height. But the numbers are different. Row height is measured in points (default 15, maximum 409), while column width is measured in characters (default 8.43, maximum 255). Do not assume the same number gives you a square cell.

If you need cells to look genuinely square — for grid layouts, calendars, or pixel-style art — pick a column width, switch to View > Page Layout, where Microsoft notes that sizes are shown in inches, centimeters, or millimeters rather than characters and points.

Mass-resizing a whole worksheet

For a full sheet reset, click the gray triangle in the top-left corner — the spot where row numbers and column letters meet. That selects every cell. Then double-click any boundary between two column headings to AutoFit them all (Microsoft's documented quick method), or run Home > Format > Column Width and type your number. Every column on the sheet changes in one move.

This same trick is useful when you import data from a CSV or paste from another app and the columns come in all over the place. AutoFit the entire sheet first, then narrow specific columns as needed. It is much faster than starting from one column at a time. If your data needs cleanup too, the CSV to Excel walkthrough covers the import side so the data lands cleanly.

Setting a default width that sticks

New sheets start at Excel's default width of 8.43 characters. You can change the standard width for the active sheet through Home > Format > Default Width. To change it for every new workbook you create, save a blank file as a template named Book.xltx in your Excel start-up folder. From then on, every fresh workbook inherits whatever widths and formatting you set in that template.

Practical examples by use case

For a financial report, set every column to the same explicit width so totals align cleanly under their headers. Use the ribbon dialog, not AutoFit, because AutoFit will widen the column the moment one cell holds a longer label, and that breaks alignment across sheets.

For a data table feeding a pivot or chart, AutoFit every column. The data does not need to print, so optimal readability beats consistency. Add a row, AutoFit again. The double-click is so fast it becomes muscle memory after a week.

For a dashboard, mix the two. Number columns get explicit widths so they line up grid-style. Label columns get AutoFit so long category names show in full. Print preview is your friend — what looks fine on screen often breaks across page boundaries, and the only fix is narrowing a few columns by one or two characters.

Width tricks for printing and exporting

Print preview will quickly show whether your widths play well with paper. Go to File > Print and watch where Excel breaks pages. If a single column is hanging onto the next sheet, narrowing it by even one character can pull it back. Alternatively, scale the sheet to fit one page wide in the Page Layout settings — but very small scaling makes the print hard to read.

When you save to PDF, widths travel with the workbook. The same goes for sharing on OneDrive or SharePoint. If somebody opens your file and complains the layout is off, the most likely cause is a different default font on their machine — covered in Excel Cheat Sheet under the font notes.

Working with frozen panes and wide columns

If you have frozen the first column for navigation, its width matters more than the others — readers see it on every scroll. Make sure that frozen column is wide enough for the longest label, and consider word-wrap (Home > Wrap Text) instead of an extremely wide single line. Combine a fixed width with wrapped text and your headers stay readable without dominating the screen.

Putting it all together

If you only remember one thing from this guide, make it the double-click. Hover the right border of any column header, double-click, done — the column AutoFits. That single trick handles most everyday resizing. For the rest, the ribbon dialog gives you exact numbers and VBA lets you script the whole thing for templates. The drag method is fine for casual work but loses to the keyboard for anything serious.

And if columns simply refuse to budge, check whether the sheet is protected, then check for hidden neighbors. With AutoFit, exact widths, and the keyboard shortcuts in your toolkit, no spreadsheet should ever leave you staring at a column full of #### again.

Tips from real spreadsheet workflows

Power users tend to keep two layouts side by side: a clean, fixed-width presentation sheet for stakeholders, and a working sheet where AutoFit reigns. The presentation sheet stays consistent week over week, while the working sheet flexes to whatever data lands. Linking the two with simple formulas means you do not have to keep formatting two views — only the working sheet changes, and the formatted sheet inherits values cleanly.

Another habit worth picking up: name the columns. Excel does not let you rename letters A, B, C, but you can turn a row of headings into a named range so formulas reference text like Revenue or Quantity instead of cryptic cell addresses. Named ranges have nothing to do with widths technically, but readable formulas remove the temptation to widen columns just to see what they contain. The shorter your formulas read, the less your widths need to compensate.

Finally, do not be afraid to reset. If a sheet looks broken — columns at odd widths, hidden columns scattered through the layout — select all, hit AutoFit, then explicit-set just the columns that need fixed sizes. It is quick and usually produces a cleaner result than trying to fix each column individually. The five methods in this guide combine into something more than the sum of their parts once you stop treating them as separate features.