Excel users have been living with a quiet absurdity for years: the moment you double-click a cell to edit it, the text rearranges itself, as if the spreadsheet is only willing to show its true self when you're not looking. This reader's question, phrased with a charming apology for asking something "bête," touches a real friction point. The words stretch wide in normal view, then snap into tighter lines the instant you enter edit mode. The cell doesn't change size. The text doesn't change content. Only the wrapping logic shifts, and that inconsistency is enough to make anyone feel like they're fighting the tool instead of using it.
Here's what's actually happening, stripped of jargon. Excel applies a default text-wrapping behavior that calculates line breaks based on the visible column width and the font metrics at rest. When you double-click, the program recalculates those breaks in an editing context, which often results in a more compact layout because the internal rendering engine uses different spacing rules. The result is that your carefully arranged two-line cell looks one way in practice and another way in edit mode. That's not a bug you caused. It's a quirk of how the software handles display versus interaction, and it's been confusing users for decades.
The practical takeaway is straightforward: you can't fully control that split behavior from the cell's default view, but you can force the issue. Use manual line breaks with Alt+Enter to dictate exactly where each line begins and ends. That overrides the automatic wrapping logic and gives you consistent results whether you're viewing or editing. The tradeoff is that you lose some flexibility if you later resize the column, but for fixed-layout tables, it's the only reliable way to make the on-screen appearance match the edit-mode preview. It's not a perfect solution, but it puts the control back in your hands, which is what you're really asking for.
This matters because the gap between what you see and what you edit shouldn't be a mystery you have to solve on your own. Spreadsheets are supposed to reduce friction, not add a second job. When a simple formatting question requires this much digging, it's a sign that the tool's defaults aren't designed for the way people actually work. So yes, you can keep your words on two lines. Use the manual break, test it, and move on. The real lesson is that you don't have to accept the tool's hidden rules as your own.