Post actualizado el día octubre 27, 2026 by DeiviSanzPlay
If you’ve ever stared at a spreadsheet that looks like a patchwork quilt because the titles are floating in the wrong place, you already know the pain. I’ve been there. A while back I was digging through a design forum and found a thread where someone was losing their mind because their Google Sheets table looked amateurish. The fix? Merge cells. Plain and simple. But the devil is in the details, and most tutorials leave out the parts that actually bite you.
Let’s cut the fluff. Here’s how to merge cells in Excel Online (the one people keep calling «Excel Drive» even though that’s not a real thing) and Google Sheets, plus the gotchas nobody warns you about until you’ve already lost data.
Excel Online: The Clunky But Functional Route
Excel Online lives inside OneDrive, not Google Drive. People search for «merge cells in excel drive» because they’re used to Google’s ecosystem and assume Microsoft copied the naming. They didn’t. But whatever you call it, the process is visual and fast enough.
Select the adjacent cells you want to join. Horizontal for a title that spans columns, vertical if you’re weird like that. Then head to the Home tab. In the Alignment group, you’ll see a button with an icon that looks like a tiny «a» next to arrows. Click the dropdown arrow beside it.
You get three real options: Merge & Center, Merge Across, and Merge Cells. Merge & Center is the crowd-pleaser because it centers the text automatically. Merge Across is for when you’ve selected multiple rows and columns but only want to merge row by row. Merge Cells just joins them without touching alignment.
Here’s the brutal truth: when you merge, only the top-left cell’s data survives. Everything else gets nuked. No undo warning beyond the standard Ctrl+Z. If you had something important in B2 through F2, it’s gone the second you click.
I’ve seen people lose entire budget rows this way. So before you merge, scan the range. If there’s data you need, concatenate it first using =A1 & » » & B1 or the CONCATENATE function, paste the result as a value into the top-left cell, then merge.
Google Sheets: Cleaner, Faster, Slightly Different Wording
Google Sheets handles merge cells in Google Sheets with the same logic but a friendlier interface. Select your cells. Go to Format in the top menu. Hover over Merge cells. You’ll see Merge all, Merge horizontally, and Merge vertically.
Merge all does exactly what it says. Merge horizontally joins each row in your selection separately—useful for creating multiple merged headers in one go. Merge vertically stacks them per column, which is rare but has its moments.
When you execute it, a tiny dialog box pops up warning about data loss. That little box has saved me more than once. It’s a split-second pause that makes you think, «Wait, is there anything in those cells I actually need?»
Speed-wise, Google Sheets wins. I’ve tested both on a shaky 4G connection. Sheets responds almost instantly for formatting actions. Excel Online sometimes lags just enough to make you click twice, which can mess up your selection.
The Keyboard Shortcut Nobody Talks About
There’s no direct Ctrl+M in Google Sheets like in desktop Excel, but you can navigate with Alt + O (Windows) or Option + O (Mac) to open the Format menu, then M for Merge cells, then arrow keys to pick your option, then Enter. Once it’s muscle memory, you’ll merge headers in under two seconds.
Undoing is just as easy: select the merged cell, go to Format > Merge cells > Unmerge. The sheet snaps back to its original grid. But remember—the data from the other cells is already gone. Unmerging doesn’t resurrect it.
When Merging Breaks Everything Else
This is the part that separates a well-designed sheet from a ticking time bomb. You cannot sort a range that contains merged cells. Excel Online will throw an error. Google Sheets will either error out or silently mess up your sort order. I’ve watched a colleague spend an hour re-sorting a sales report because she’d merged the header row and forgot about it.
Merged cells are static formatting tools. They’re perfect for titles, section labels, and report headers that never move. They’re terrible for data rows that need to be filtered, sorted, or manipulated dynamically.
Another trap: if you later insert columns next to a merged cell, the merge doesn’t expand. You have to unmerge, reselect a wider range, and merge again. Planning your column structure upfront saves you that headache.
Excel Online vs Google Sheets: Which Merge Wins?
For pure how to merge cells in Excel from Google Drive confusion—there’s no Excel inside Drive. You’re thinking of Google Sheets. And honestly, for basic merging, Sheets is the better tool. The menu names are clearer, the warning dialog is more explicit, and it’s faster on weak connections.
Excel Online wins if you’re already embedded in the Microsoft 365 ecosystem and need the merged output to sync with desktop Excel formatting. But if you’re just making a clean header for a shared budget tracker, Sheets is the path of least resistance.
One more thing: merged cells are a nightmare for screen readers and accessibility. If your spreadsheet needs to be accessible, avoid merging entirely and use center-across-selection instead. It looks the same but keeps the underlying grid intact.
FAQ: Merging Cells Without the Migraine
How do you merge cells in Excel Online without losing data? You can’t with the native feature. The workaround is to concatenate all values into the top-left cell first using a formula like =A1 & » » & B1 & » » & C1, copy that result, paste it as plain text into the top-left cell, then merge.
Can you merge cells in Google Sheets on mobile? Yes. Select cells by tapping and dragging, tap the format icon (the «A» with lines), then choose Merge cells. The same data-loss warning appears. The mobile app handles it fine, though precise selection on a small screen is fiddly.
Why can’t I merge cells in Excel Online? Usually because the range includes part of a table (Excel tables don’t allow merges) or the sheet is protected. Check for those two culprits first.
Does merging cells affect formulas? Yes. If a formula references a cell that gets merged away, it’ll return a #REF! error. Always check your formulas before merging.
Bottom line: merging cells is a five-second action with a five-minute consequence if you’re careless. Select wisely, back up your data, and never merge a row you plan to sort later. Do that, and your spreadsheets will look sharp without costing you your sanity.