How to Change Column Width in Excel: Every Method, Shortcut, and Fix

Columns in Excel start at a fixed width of about 8.43 characters. That looks fine for short numbers. It falls apart the moment you paste in a long header, a phone number, or any text bigger than the cell can fit. Then you get cut-off labels or a row of ######## warning marks that scream "this number won't fit."

Fixing it takes seconds once you know the moves. This guide walks through every method, plus the shortcut, the VBA snippet, and the small differences on Mac.

Pick whichever fits your task — drag for one column, AutoFit when you've got mixed content, the Format menu when you need exact numbers, and the default-width setting when you want every new column in the workbook to start wider. None of it is hard.

Most users just never learned the keyboard shortcut, and they end up dragging borders all afternoon. That's the real time sink. Five seconds here, ten seconds there — by Friday you've burned an hour on something a four-key combo solves instantly.

You'll also pick up some Excel quirks along the way. How the program actually measures "width." Why a column looks one size on your screen and another on your colleague's. What to do when pasted data refuses to keep its formatting. Small details, but they save real time once you stop fighting them.

By the end of this you'll have a complete mental toolbox for column width. You'll know which method fits which situation, when to AutoFit and when to set manual values, and how to keep widths consistent across sheets, machines, and printed pages. The same patterns apply to row height too — but more on that later.

There are roughly seven ways to change column width in Excel, and each one has a moment when it's the best tool.

Drag the border between two column headers — that's the fastest method when you're eyeballing things. Right-click any column letter and pick Column Width to type an exact number.

Go to the Home tab, click Format in the Cells group, and you'll see the same option from the ribbon. Double-click the right-hand border of a column header and Excel snaps the column to the longest cell content — that's AutoFit, and it's a lifesaver for messy imported data.

Need to change several columns at once? Select them first. Click the letter of the first column, then Shift+click the last to grab a range, or Ctrl+click to pick non-adjacent ones. Now drag any one border and they all resize together.

Same with right-click → Column Width — your number applies to every selected column. When you want the default for new columns to be wider across the whole worksheet, go to Home → Format → Default Width and type the new value.

From that point, any column you haven't manually resized takes the new default. Existing custom widths stay put. That's important — Excel respects your manual settings even when you change the default.

One trap worth knowing about. If you've already set a custom width on a column and then change the default, that column doesn't budge. Excel treats your manual width as an override. To get everything back to a clean baseline, select all columns (Ctrl+A), right-click, pick Column Width, and type your number. Now every column matches.

There's also the often-forgotten right-click-on-cell route. Select any cell in the column you want to resize, right-click, and pick Column Width. Excel applies the value to the entire column the cell belongs to. Handy when you're already deep in a worksheet and don't want to scroll back to the header row.

The keyboard shortcut deserves its own moment. Press Alt, then H, then O, then W — that's Home, fOrmat, Width. The Column Width dialog pops up. Type your number. Hit Enter. Done.

It looks awkward written out but it takes about a second once your fingers learn it. Far faster than reaching for the mouse, hunting for the column border, and dragging.

Microsoft uses this same Alt-key pattern across the whole ribbon, so once you get the rhythm you'll start spotting shortcuts everywhere. The Alt key shows you the access letters on every visible button — try pressing just Alt by itself once and you'll see them light up across the ribbon.

For AutoFit there's Alt + H + O + I (the I stands for "autofIt column width"). Select the columns you want sized to content, hit those four keys, and Excel measures the longest entry and matches the width to it.

Pair it with Ctrl+A first if you want to AutoFit every column in the sheet in one motion. Two shortcuts, twelve seconds, a whole spreadsheet cleaned up. Beats opening every dialog one column at a time.

For row height the parallel shortcuts work the same way: Alt + H + O + H opens row Height, Alt + H + O + A triggers AutoFit row height. Once you have the column ones in muscle memory, the row versions are just one letter different.

Here's a quirk that confuses people. Excel measures column width in character units, not pixels or inches. One unit equals the width of one zero character in the default font (Calibri 11 in modern Excel). So a column set to "10" fits roughly ten zeros side by side.

When you drag a border, Excel shows both the character width and the pixel width in a tooltip — useful when you're matching multiple sheets or trying to fit a printable area exactly. Switch fonts and the visible width changes even though the number stays the same. That's why a workbook designed in Arial can look squashed when opened in Calibri.

The pixel count depends on your screen resolution and DPI settings, which is why your column looks one width on your laptop and another on a coworker's monitor. The character value is the only number that stays consistent across machines. If you're sharing templates with a team, lock the column widths using the character number, not by visual eyeballing. And if you really need exact print measurements in inches or centimeters, switch to Page Layout view (View tab → Page Layout). There Excel shows ruler measurements you can drag with normal real-world units.

Those ######## symbols aren't an error. Excel uses them as a polite warning that a numeric value won't fit in the cell at the current width. The number is still there — just hidden until you make room. Double-click the right edge of the column header to AutoFit, or drag the border wider until the digits appear. The hashes will vanish instantly. Dates and times do the same thing when their column gets too narrow.

Text doesn't get the hash treatment. Instead, it spills into the next cell — but only if the neighboring cell is empty. The moment you type anything next door, the overflow disappears (the text is still in the original cell, just hidden). If you'd rather have the text wrap inside the cell instead of spilling, hit Wrap Text on the Home tab. Now the row height grows to fit the content and the column width can stay narrower. Mixing wrap text with AutoFit Row Height keeps things tidy when you've got long labels and limited horizontal room.

Pasting data into Excel almost always loses column widths. The default Paste copies values and formatting, but not column dimensions — so freshly pasted data ends up squashed into whatever widths the destination sheet had. Annoying when you've spent time formatting a source workbook nicely.

The fix is Paste Special. After pasting normally, click the small paste options icon that appears in the bottom-right corner of the pasted area, then choose Keep Source Column Widths. Excel reapplies the original widths to match the source. Or skip the regular paste and go straight to Home → Paste → Keep Source Column Widths. Same result, one step shorter. Either way the destination columns now mirror the original.

When you're copying entire sheets between workbooks, right-click the sheet tab and pick Move or Copy instead. That carries every column width, row height, named range, and formula across in one motion. Cleaner than copy-paste for anything bigger than a small block.

Automating column widths with VBA is straightforward. Open the VBA editor with Alt+F11, insert a new module, and type a line like Columns("A").ColumnWidth = 15 to set column A to 15 character units. Want multiple columns? Columns("A:D").ColumnWidth = 12 handles a range in one shot. Or use the Range syntax: Range("A1:D1").EntireColumn.ColumnWidth = 20 when you're working from a specific cell reference.

AutoFit by code is just as simple: Columns("A:Z").AutoFit sizes every column from A to Z based on content. Run that as the last line of an import macro and your data lands clean every time. If you need different widths per column, a small loop does the trick: For i = 1 To 5: Columns(i).ColumnWidth = 10 + i: Next i. Save your widths to a variable before any operation that might disturb them, and you can always restore them later. Useful when you're inserting rows, sorting, or doing anything that touches column structure.

Mac Excel handles column width with mostly the same logic but a few different menu paths. The drag, right-click → Column Width, and double-click AutoFit moves all work identically. The Home tab → Format dropdown is in the same place. Where it diverges is the keyboard shortcut.

Mac doesn't use the Alt key the same way Windows does, so the Alt + H + O + W sequence won't work. On Mac, press Control + Option + R to open the row & column menu, then pick Column Width. Or assign your own shortcut through Tools → Customize Keyboard if you use it constantly.

Default Width on Mac sits under Format → Column → Standard Width from the menu bar (not the ribbon). Same dialog, just different route. VBA exists on Mac Excel but with some caveats — ActiveX controls and a few automation features are stripped out, though basic Columns().ColumnWidth commands work everywhere. If you're sharing a workbook between Windows and Mac users, stick to the cross-platform features and test on both before locking anything down.

Things still going wrong? A few troubleshooting moves cover most of the weird cases. If a column refuses to resize at all, check whether the worksheet is protected. Go to Review → Protect Sheet — if it's on, you'll need the password (or to unprotect) before formatting changes. Same goes for shared workbooks in older Excel versions, where some structural edits get locked while sharing is active.

If AutoFit keeps making columns way too wide, look for hidden long content. A pasted-in cell with hundreds of characters can stretch a column past 100 units even when the rest of the data is short. Either trim that one cell or set a manual width afterward — manual always wins over AutoFit. When dragging doesn't seem to do anything visible, you're probably hovering between the wrong borders. The cursor must be exactly between two column letters in the header row, not between row numbers and not inside the data. Look for the double-arrow icon before you click.

Frozen panes can also mess with how column resizing looks. If you've frozen the top row or a left column for scrolling, resizing a column on one side of the freeze affects only that side visually until you scroll. The width itself is consistent — the display just doesn't update both panes until you unfreeze (View → Freeze Panes → Unfreeze) or scroll. Worth checking before you assume the resize failed.

Printing brings its own column width considerations. What looks fine on screen can spill onto a second page when you hit print. Open File → Print and check the preview before sending anything to paper. If columns are getting cut off, you have three options: shrink the columns, fit to one page wide, or switch to landscape orientation.

Fit-to-page sits under Page Layout → Scale to Fit. Set Width to 1 page and Height to Automatic — Excel will shrink everything proportionally to fit one page across. It's a quick fix, but very wide sheets end up tiny and unreadable. Better to manually narrow columns where you can and use landscape for the rest. Page breaks show up as dotted lines on the worksheet after you've previewed once. Drag those manually in View → Page Break Preview mode if you want to control exactly which columns land on which page.

For consistent printed output across a workbook, use View → Page Layout to design with real measurements in inches or centimeters. The ruler at the top shows actual print width. Set your columns there and you'll know exactly how the printout will look — no surprises in the preview.

Column width is one of those tiny mechanics that pays you back forever once you have it down. Drag for speed, AutoFit when you need precision, the Format menu for exact numbers, Alt + H + O + W when your hands are already on the keyboard. Mix them based on the moment. You'll start saving real minutes per workbook — minutes that add up across a workweek of spreadsheets.

Combine column width control with row height adjustments and you've got the basics of layout in Excel locked down. Row height works almost identically — drag the bottom border of a row number, right-click for an exact value, or double-click to AutoFit. The same Alt-key sequence opens the row dialog: Alt + H + O + H for row Height, Alt + H + O + A for AutoFit row height. Worth committing to memory alongside the column ones.

If you're brushing up on Excel basics for a certification or a job interview, knowing these formatting moves cold is table stakes. Test yourself with a practice run before you sit down for the real thing. The questions are quick, the feedback is immediate, and you'll spot the gaps in your knowledge before they cost you points. Better to find out you're rusty on the basics now than mid-interview.