Adjust Column Width in Excel: The Right Way

What You'll Be Able to Do, and Why Adjusting Column Width in Excel Is Worth Getting Right

A spreadsheet that makes people work harder to read it is a bad spreadsheet. I've spent 12+ years in Excel (consulting, healthcare operations, logistics) and column width is still one of the most overlooked things I see in other people's files. Truncated labels. Rows crammed so tight the data bleeds. Numbers replaced by ###### because no one bothered to adjust column width in Excel before sharing the file. It costs nothing to fix, and it costs everyone time when it's not fixed.

This article covers every method worth knowing: mouse drag for quick one-off changes, AutoFit for bulk resizing, exact values for print-ready layouts, and how to copy column widths across sheets without redoing the work. No special skills needed, just an open workbook and a few minutes. If you're newer to Excel and want more context on the basics, the Excel for Beginners starter guide has solid background before diving in here.

---

Step 1: Adjust Column Width and Row Height with the Mouse (Quickest for One-Off Changes)

This is the method everyone learns first. It's fast, requires no menus, and works for both columns and row height. The catch: it requires a steady hand, and clicking one pixel off the border just selects the column instead of resizing it. That's the most common stumble. Worth knowing in advance so you don't spend thirty seconds wondering why nothing's happening.

Drag to resize a single column or row

1. Hover over the right edge of a column header (the border between, say, column A and column B) until your cursor becomes a double-headed arrow.
2. Click and drag right to widen, left to narrow.
3. Release when the column is the width you want.

Row height works the same way: hover over the bottom edge of a row number until the cursor changes, then drag up or down. Microsoft 365 shows a live tooltip with the exact measurement as you drag, which is genuinely useful when you need a consistent row height across a report.

Resize multiple columns or rows at once

Select multiple column headers by clicking the first and shift-clicking the last (or Ctrl-clicking non-adjacent ones). Then drag any one of the selected borders. Every selected column resizes to the same width simultaneously. The same logic applies to rows. This is how you resize multiple columns at once without touching each one individually, and it's something the overview of rows, columns, and cells doesn't always cover in depth.

If your double-headed cursor refuses to appear, you're likely hovering inside the column header instead of on its border. Move the cursor a pixel or two until you see the arrow change shape, then click.

---

Step 2: Use AutoFit to Let Excel Adjust Column Width Automatically (And When It Lets You Down)

Once you've done the manual drag a few hundred times, you start wanting Excel to just figure it out. AutoFit does that: it reads the widest content in a column and sizes accordingly. Fast, accurate, and a legitimate column width shortcut in Excel worth having memorized.

Running AutoFit from the ribbon and with a double-click

Select the columns you want to resize, then go to Home → Format → AutoFit Column Width. Or, the faster move, just double-click the right border of any column header. Excel sizes it instantly. For row height, double-click the bottom border of a row number. I've had this in my personal shortcut rotation since 2013 when I first sat the MOS certification exam. Still use it daily.

Why AutoFit fails when Wrap Text is on, and the fix

Here's the one the tutorials always skip. If Wrap Text is enabled on a cell, AutoFit can't correctly calculate the column width it needs. It sizes to the raw text length, ignoring the wrapping. You end up with rows that are too tall and columns that are still too narrow.

The fix: temporarily turn off Wrap Text (Home → Wrap Text to toggle it off), run AutoFit, then re-enable Wrap Text. Takes ten seconds. I used to mess this up too, and I've seen it trip up people with years of Excel experience. It's one of those things that feels like a bug but isn't, it's just AutoFit doing exactly what it's told, which happens to be the wrong thing in that context.

---

Step 3: Set Column Width in Inches for Printing (The Page Layout View Trick Most Guides Skip)

AutoFit is great for screen readability. It's less useful when you need a sheet to fit a printed page. This is something I feel pretty strongly about: I still physically test print layouts before publishing any tutorial, and a column that looks fine on a 27-inch monitor can get cut off completely on a printed page.

Switch to View → Page Layout. In this view, Excel switches the column width and row height units from "characters" to inches (or centimeters, or millimeters; set your preference under File → Options → Advanced → Display → Ruler units). Now you can set column widths in real-world measurements, which makes designing a print-ready sheet far less of a guessing game than trying to reverse-engineer what "8.43 characters" looks like on paper.

For exact values in standard view, right-click any column header and choose Column Width, then type a number. Same for row height. The dialog boxes are blunt instruments, but they're useful when you need a precise, consistent default column width across a shared workbook.

As of 2026, Microsoft still hasn't made the print layout workflow as visible as it deserves to be. Ctrl+F2 gets you to Print Preview fast: check it after every major formatting change.

The advanced Excel basics guide covers more on print setup if you want to go deeper.

---

Common Mistakes When You Adjust Column Width in Excel, and What to Do Instead

Three things I see constantly, even from experienced users.

First: AutoFit breaking because Wrap Text is on. We covered the fix above: toggle off, AutoFit, toggle back. Keep it in mind anytime AutoFit gives you a weird result.

Second: resizing columns one at a time when you could select all of them and drag once. If you've got twelve columns that all need to be the same width, select all twelve headers first. One drag. Done.

Third, and this one's almost universally missed, you can copy a column's exact width to another sheet without doing it by hand. Select a cell in the column you want to copy, press Ctrl+C, then go to the destination sheet and use Paste Special → Keep Source Column Widths. The width transfers. No guessing, no dragging to match.

If you're working with data that changes size regularly (updated feeds, shifting report lengths) those three manual methods will only get you so far. VBA can automate column resizing entirely: a simple Columns.AutoFit call inside a macro runs every time the sheet updates. It's a short script that saves real time. Worth looking into if your data isn't static.

---