Merging cells in Google Sheets joins two or more selected cells into one. Select the cells, open Format, then Merge cells, and pick Merge all, Merge horizontally, or Merge vertically.
One thing to know up front: a standard merge keeps only the value in the top-left cell and clears the rest. If you need to keep every value, you combine the cells with a formula instead. This guide covers both, plus how to unmerge and a cleaner alternative when you only want the look of a merge.
What Cells Are in Google Sheets
A cell is one box in the grid, named by its column letter and row number: A1, B2, C3. Columns run vertically (A, B, C), rows run horizontally (1, 2, 3).
Merging takes a block of these cells and turns it into a single, larger cell. That is the move behind every clean title row and spanning header you have seen in a sheet.
When to Merge Cells (and When Not To)
Merge cells when you want a header to span several columns, a clean title at the top of a report, or a label that sits across a group of data. It is a layout tool.
Do not merge cells inside a range you plan to sort, filter, or run formulas across. Merged cells break those operations and throw errors. If the data is live, keep it unmerged and use Center across selection (covered below) for the same visual result.
A Quick Example
Say you collect signups through a form that feeds a Google Sheet (Formester forms write straight to Sheets through the native Google Sheets integration). You want a single title across the name, email, and status columns at the top. Merging those three header cells gives you one clean banner instead of three half-filled boxes.
How to Merge Cells in Google Sheets: Step by Step
- Select the cells. Click and drag to highlight the adjacent cells you want to merge. They have to be next to each other in a continuous block.
- Open the merge menu. Go to Format in the top menu, then click Merge cells. You can also click the merge icon in the toolbar for the same options.
- Pick how to merge. Choose one of three:
- Merge all: combines every selected cell into one large cell.
- Merge horizontally: merges each row of the selection into a single wide cell.
- Merge vertically: merges each column of the selection into a single tall cell.
Quick path with the keyboard: open the Format menu with the toolbar merge button rather than hunting for a shortcut. Google Sheets has no fixed default merge hotkey, so power users assign one with a macro under Extensions, then Macros.
How to Merge Cells Without Losing Data
The standard merge keeps only the top-left value and deletes the rest. When you actually need to keep both values, combine the cells with a formula instead of merging them.
Ampersand operator (&)
The fastest way to join two cells. Put a space in quotes between them so the values do not run together:
- =A1&" "&B1 turns "Jane" and "Doe" into "Jane Doe".
CONCATENATE function
Does the same thing, spelled out, which some teams prefer for readability:
- =CONCATENATE(A1," ",B1) returns "Jane Doe".
TEXTJOIN for a whole range
When you are joining many cells, TEXTJOIN handles the range and the separator in one go and skips blanks:
- =TEXTJOIN(" ",TRUE,A1:D1) joins everything in A1 through D1 with a single space between each value.
Pick the separator to match the data: a space for names, a comma for lists, a line break with CHAR(10) for stacked addresses.
Center Across Selection: The Look of a Merge Without the Problems
If you only want a title to look centered across several columns, you do not have to merge at all. Center across selection gives the same visual span while keeping every cell intact, so sorting and formulas still work.
- Type your text in the leftmost cell of the range.
- Select the leftmost cell plus the empty cells you want it to span.
- Set horizontal alignment to Center using the toolbar align button.
The text now sits centered across the group, but the cells underneath stay separate. This is the safer choice for any header that sits on top of live data.
Things to Remember Before You Merge
- Plan the layout first. Merging is hard to work around later, so decide where headers and titles go before you commit.
- Use it sparingly. Too many merged cells make a sheet hard to navigate, sort, and edit.
- Keep it off live data. Never merge inside a range you sort, filter, or run formulas across; use a formula or Center across selection instead.
- Format after merging. Set alignment, borders, and fill on the merged cell to finish the look.
How to Unmerge Cells
- Click the merged cell you want to split back apart.
- Open Format, then Merge cells, and choose Unmerge. (You can also click the merge icon again to toggle it off.)
The cells split back to their original grid. One thing to expect: the value that survived the merge stays in the top-left cell, and the others come back empty. There is no way to recover data that the merge deleted, so undo with Ctrl+Z if you unmerged by mistake.
Common Problems and How to Fix Them
- Lost data after a merge: only the top-left value survives a standard merge. Undo with Ctrl+Z, then combine the cells with a formula instead.
- Merge option greyed out: your selection is not a continuous block, or the cells sit inside a table or protected range. Reselect an adjacent block and try again.
- Sorting or filtering throws an error: a merged cell sits inside the range. Unmerge it, or switch the header to Center across selection.
- Merged cells break on export: merged formatting can shift when a sheet opens in Excel or another tool. If portability matters, keep the data unmerged.
Merging Cells in Excel and Google Docs
The idea carries over, the path changes:
- Excel: select the cells, then Home, then Merge & Center (it has a dropdown for Merge Across and Merge Cells). Excel also warns before deleting the non-top-left values.
- Google Docs tables: select the cells in the table, right-click, and choose Merge cells. Docs cannot merge cells outside a table.
If you move sheets between Google and Excel often, lean on formulas over merges; they survive the round trip cleanly.
Put Your Sheet on Autopilot
Merging is a layout finish, not a data tool. Reach for it on headers and titles, reach for formulas when you need to keep values, and reach for Center across selection when you just want the look.
If you are merging header rows on a sheet that you update by hand, the bigger win is getting data into it automatically. Connect a form to your sheet and new responses land as fresh rows with no copy-paste: see how to send form responses straight to Google Sheets.
