How to Lock Column Width in Excel for Good

A shared budget tracker looks perfect on Friday. By Monday, three colleagues have opened it, and the neat column widths that took twenty minutes to tune are now stretched, squashed, and wrapping text in ways that make the whole thing unreadable. Somebody widened column C to fit a long note. Someone else double-clicked a border and auto-fit half the sheet. Point is, sizing in Excel counts as formatting, and formatting is fair game for anyone with edit access. So the layout drifts. If you need how to lock column width in Excel to actually hold in a shared file, this is why. And here’s the frustrating part – most people already tried to fix this. They turned on Protect Sheet, saved, shared the file again, and the columns kept moving anyway. There’s one step everyone skips, and it’s the one that actually makes the lock stick.

Why “Just Protect the Sheet” Doesn’t Work

Here’s the trap. You go to Review, click Protect Sheet, set a password, hit OK. Feels done. But that dialog has a long list of checkboxes, and by default several are already ticked – including “Format columns” and “Format rows.” Those two permissions are exactly what let someone resize. So protection is on, yet the thing you wanted protected is still wide open. This is the gap nobody explains clearly. Most guides tell you to protect the sheet and stop there. They skip the Locked attribute entirely, and they skip the two formatting checkboxes that control sizing. You follow every step, feel like you did it right, and the columns still resize on you. Microsoft’s own community threads are full of people hitting this exact wall, asking how to lock column width but still let colleagues type in the cells. Then there’s the second half of the problem, the Locked attribute. Every cell in Excel is set to “Locked” by default, but that setting does absolutely nothing until Protect Sheet is switched on. People assume Locked means locked. It doesn’t, not on its own. It’s just a flag that Protect Sheet reads later. So learning how to lock column width in Excel really comes down to getting three moving parts to line up: the Locked flag, sheet protection, and the specific formatting permissions inside that protection dialog.

How to Lock Column Width in Excel and Freeze Cell Size

Let’s take a look at the method that holds. The goal is to prevent Excel column resize while still letting people edit the data inside the cells, because a fully locked sheet where nobody can type is usually worse than the original problem. Here’s the sequence that works:

1. Set your column widths and row heights exactly how you want them first. Right-click any column header, choose Column Width, type a number. Do the same for rows via Row Height. Get this done before you protect anything.
2. Select the cells people should still be able to edit. Right-click, choose Format Cells, open the Protection tab, and untick Locked. That carves out the editable zone.
3. Go to Review, then Protect Sheet.
4. In the dialog, leave “Select locked cells” and “Select unlocked cells” ticked so navigation still works.
5. Now the part that matters: scroll down and make sure “Format columns” and “Format rows” are unchecked.
6. Set a password if you want it enforced, and click OK.

That’s the combination most guides miss. Unchecking those two formatting options is what actually locks cell size. Protection without that step leaves the door open.

“Locked cells do nothing until Protect Sheet is on, and Protect Sheet does nothing about sizing until you uncheck Format columns and Format rows. Both halves have to be true at once.”

Setting It Up: The Exact Path and What Each Toggle Does

Menu paths trip people up because the sizing controls live in two different places. Column width and row height get set through the right-click header menu, or through Home, then Format, then Column Width / Row Height. The lock itself lives under Review, then Protect Sheet. Here’s what the relevant checkboxes in the Protect Sheet dialog actually control: The row height point deserves its own mention. When Excel row height keeps changing, the usual culprit is text wrapping or a merged cell forcing rows to auto-expand as data gets typed. Uncheck “Format rows” under protection and the height freezes no matter what gets entered, so a row set to 20 pixels stays at 20 even when someone pastes a paragraph into it. One more setting worth knowing. If you want people editing values but never touching structure, also uncheck “Insert columns,” “Delete columns,” “Insert rows,” and “Delete rows.” Adding or removing columns reshuffles everything and undoes your careful sizing just as fast as a manual drag.

Troubleshooting: When the Lock Still Doesn’t Hold

Even after the correct steps, a few things go sideways. Here are the common ones and what’s really happening. The lock works but nobody can type. That means the sheet got protected without the data cells being unlocked first. Unprotect the sheet, select the input range, untick Locked in Format Cells, then reprotect. Order matters – the unlock has to happen before protection goes on. Columns still resize after protecting. Almost always, this is “Format columns” left checked. Unprotect, reopen Protect Sheet, scroll the list, uncheck it, protect again. Microsoft’s Q&A forums point to this same fix repeatedly for people asking how to protect sheet formatting in Excel. Merged cells keep changing row height. Merged cells and auto-fit fight each other constantly. If a merged cell is what drives Excel row height changing behaviour, unmerge where you can and use “Center Across Selection” from the alignment options instead – looks the same, doesn’t force resizing. The whole workbook, not one sheet. Protect Sheet only covers the active tab. Twelve tabs means protecting twelve times, or scripting it. There’s no single button that locks cell size across every sheet at once in the standard dialog. Password recovery is its own headache. Excel sheet passwords are easy to lose and there’s no official reset, so store the password somewhere findable. Losing it means rebuilding protection from an unprotected copy, assuming one exists.

FAQ

Does locking column width stop people from editing the cell contents too? No, not if it’s set up right. Untick Locked on the data cells before protecting, and people can still type, paste, and edit values. Only the column width and row height stay frozen. The two behaviours are controlled separately, which is exactly why the Locked attribute step matters so much. Why do my columns still resize even though I protected the sheet? Because “Format columns” was left checked in the Protect Sheet dialog. That single permission overrides everything else and lets people drag borders and auto-fit. Unprotect, reopen the dialog, uncheck both “Format columns” and “Format rows,” and reprotect. Most guides leave this step out. How do I lock cell size across an entire workbook, not just one tab? The standard Protect Sheet command works one sheet at a time, so you repeat it per tab. For a lot of sheets, a short VBA macro looping through each worksheet and applying protection with the format options disabled is the practical route. There’s no native “protect all sheets” checkbox for this. Can I stop the row height from changing when someone types a long entry? Yes. Unchecking “Format rows” under Protect Sheet freezes the height even as data grows. And if a merged cell is forcing the resize, replace the merge with “Center Across Selection,” which keeps the visual layout without triggering auto-expansion. Is there a way to lock sizing without a password? Yes, just click OK in the Protect Sheet dialog without entering one. Protection still applies and the format options still hold. A password only stops someone from unprotecting the sheet and undoing your work, so for a genuinely shared file it’s worth adding one.

Wrapping Up

How to lock column width in Excel isn’t one switch, it’s two halves that have to agree. The Locked attribute flags which cells are protected, and Protect Sheet enforces it – but only if you uncheck “Format columns” and “Format rows” inside that dialog. Miss that step and you’ll do everything else correctly while the columns keep drifting. Set widths first, unlock the cells people edit, then protect with the formatting boxes off. That’s the whole trick, and it’s the part the usual advice skips.