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. The good news is that Excel gives you five different ways to do it, and once you learn the shortcuts you will probably never reach for the mouse again.
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 the difference between Excel's pixel measurements on Windows and Mac.
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 roughly 8.43 zeros fit in the cell at the default Calibri 11. That is why widths look different across machines: change the default font, and every number shifts.
Hover the right edge of the column header until the cursor turns into a double arrow, then drag left or right.
Double-clicking that same border snaps the column to the widest cell in it — fastest method by far.
Home > Format > Column Width opens a dialog where you type an exact number.
Alt+H, O, W on Windows opens the same dialog without touching the mouse.
Columns("A:D").ColumnWidth = 15 resizes whole ranges in one line — great for templates.
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 in characters and pixels, 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.
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, plus the keyboard shortcut Alt+H, O, I, is covered in the dedicated AutoFit Excel guide.
Select the columns you want to change, then press Alt, H, O, W in sequence (release each key before the next). The Column Width dialog opens. Type a number between 0 and 255, press Enter. To AutoFit instead, use Alt, H, O, I. To set the width for every column on the sheet, click the gray triangle in the top-left corner of the grid before running the shortcut.
macOS does not use the same Alt-key ribbon shortcuts. Select your columns and press Control + Option + 0 (zero) to open the Column Width dialog, or use the menu path Format > Column > Width. AutoFit lives at Format > Column > AutoFit Selection. You can also right-click any column header and pick Column Width from the contextual menu — it works on both platforms.
The browser version trims a few features. AutoFit by double-click still works on the column border. The Home > Format > Column Width dialog is also present, but VBA is not available — that is a desktop-only feature. If you need macros to resize columns programmatically, you must open the workbook in Excel for Windows or Mac.
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. 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. So 10 means 10 zeros wide at Calibri 11. If your workbook uses a different default font, that same 10 will produce a slightly different pixel count. To set the width for the whole sheet at once, click the gray triangle in the top-left corner of the worksheet — between the column A header and the row 1 header — to select everything, then run the same Format > Column Width command.
Excel exposes two related settings. Column Width changes the selected columns only. Default Width changes every column on the active sheet that has not been adjusted manually. Find both under Home > Format. Default Width is useful when you want a new sheet to start with wider columns without touching every column individually.
If you spend hours in spreadsheets, keyboard shortcuts are the single biggest win. The ribbon shortcut for column width on Windows is Alt, H, O, W — press the keys in sequence, not together. Excel highlights each ribbon group as you press, so you can see what is happening. For AutoFit, the sequence is Alt, H, O, I. To hide a column entirely use Ctrl+0; to unhide, select the columns on either side and press Ctrl+Shift+0.
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 lists more than 80 keys for Windows and Mac.
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.
Sometimes a column ignores every method above. Nine times out of ten the worksheet is protected. Go to Review > Unprotect Sheet, enter the password if there is one, and try again. If the workbook is shared or in co-authoring mode, structural changes can be blocked too — switch to local editing or take ownership before resizing.
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.
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 (1/72 of an inch), not characters. So a row height of 15 is roughly 20 pixels at standard resolution, while a column width of 15 is roughly 110 pixels. 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 (which uses inches), then set the row height to the same number of inches. The conversion is automatic in that view.
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 either double-click any column border to AutoFit them all, 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.
Every new sheet starts at width 8.43 because that is Excel's default. You can change this for a single workbook through Home > Format > Default Width, which only affects untouched columns on the active sheet. 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.
For a financial report, set every column to the same explicit width — typically between 10 and 14 characters — 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.
Mobile Excel resizes columns through a long-press on the column header. A blue handle appears on the right edge; drag it left or right. AutoFit lives on the same contextual menu as Hide and Unhide. The pixel-perfect ribbon dialog is not there — for exact widths you need the desktop app. That is rarely a problem because mobile spreadsheets are usually viewed, not designed.
Excel on iPad supports an external keyboard, but the Alt-key shortcuts that work on Windows do not map cleanly. Use the menus or the touch handles. If you build templates that will be viewed on mobile, set explicit widths on the desktop first — they travel with the file.
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, use Page Layout > Width and set it to one page so Excel scales the whole sheet down — but be careful, very narrow scaling makes the print unreadable.
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.
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.
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 maybe 80 percent of real-world resizing. For the other 20 percent, 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 protection, then check for hidden neighbors, then check whether the worksheet is in co-authoring. Those three reasons cover almost every stuck-column complaint. With AutoFit, exact widths, and the keyboard shortcuts in your toolkit, no spreadsheet should ever leave you staring at a column full of #### again.
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 takes about thirty seconds and almost always 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.