How to Merge Cells in Google Sheets (2026 Guide)
To merge cells in Google Sheets, select the cells you want to combine, then click the Merge cells icon in the toolbar or go to Format > Merge cells. You can merge everything into one cell, merge each row, or merge each column. Here are all the options, how to unmerge, and the sorting caveat that trips people up.
1. Merge All Cells
This combines your entire selection into a single cell. It is the most common choice for a title row that spans the width of a table.
- Click and drag to select the adjacent cells, for example A1:D1.
- Click the Merge cells icon in the toolbar (two arrows pointing into a box). The default action is Merge all.
- The cells become one. The value from the top-left cell is kept; any other values are discarded.
If the selection holds data in more than one cell, Sheets warns you that only the top-left value will be kept. Click OK to continue or cancel and move the data first.
You can also reach this from the menu: Format > Merge cells > Merge all.
2. Merge Horizontally
Use this when you have selected several rows and want each row merged on its own, across columns.
- Select a block, for example A1:C3 (three rows, three columns).
- Go to Format > Merge cells > Merge horizontally.
- Each row merges separately, so you end up with one merged cell per row (three merged cells, not one).
This is handy for stacked banners or section labels where every row needs its own wide cell.
3. Merge Vertically
The mirror image: each column in the selection merges down into one cell.
- Select a block, for example A1:C3.
- Go to Format > Merge cells > Merge vertically.
- Each column merges into a single tall cell, so you get one merged cell per column.
This works well for a label that should sit beside several rows of data, such as a category name next to a group of items.
4. Center Text Across Columns Without Merging
Merging can break sorting and formulas (see below). If you only want a title to appear centered over several columns, there is a cleaner trick that avoids merging:
- Type the title in the left-most cell, for example A1.
- Leave the cells to its right (B1, C1) empty.
- Select A1:C1.
- Click the Horizontal align button in the toolbar and choose Center.
The text is visually centered across the columns because it overflows into the empty cells to the right, but each cell stays independent. There is no true “center across selection” command in Sheets, this overflow method is the standard workaround.
5. Unmerge Cells
- Click the merged cell to select it.
- Click the Merge cells icon in the toolbar again (it acts as a toggle), or go to Format > Merge cells > Unmerge.
- The cell splits back into individual cells. The content stays in the top-left (or left-most) cell; the others come back empty.
To unmerge everything at once, select the whole sheet first by clicking the blank corner box above row 1, then choose Unmerge.
Merging and Sorting: the Caveat
Merged cells and sorting do not mix. If a range contains merged cells and you try to sort it, Sheets shows the error “You can’t perform this action on a merged cell” and refuses to sort.
Because of this, avoid merging cells inside the actual data rows of a table you plan to sort, filter, or run formulas across. Merged cells also confuse functions like VLOOKUP and SUM, since the merged area only holds one real value (in the top-left cell) and the rest read as blank.
Safe places to merge: title rows, header banners, and dashboard labels. Unsafe places: the body of a data table you sort or analyze. When in doubt, use the center-across-columns method in step 4 instead.
Quick Reference
| Goal | Command |
|---|---|
| One big cell | Merge all |
| One cell per row | Merge horizontally |
| One cell per column | Merge vertically |
| Centered title, no merge | Align Center over empty cells |
| Split back apart | Unmerge (toggle the merge icon) |
Stop Reformatting the Same Reports by Hand
Merged headers make a report look clean, but rebuilding that layout every week is busywork. Carly is an AI assistant that connects to 200+ apps including Google Sheets and handles the repetitive follow-through, logging fresh data into your formatted sheet, pulling totals into an email, and sending the recurring report so you are not copy-pasting into the same template every Monday. Carly starts at $35/month.
More on Google Sheets: How to freeze rows in Google Sheets · How to use conditional formatting in Google Sheets · How to create a pivot table in Google Sheets · Google Sheets integration
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
