To merge cells in Google Sheets, select the cells, click Format > Merge cells, and choose Merge all, Merge horizontally, or Merge vertically. To split them again, select the merged cell and choose Format > Merge cells > Unmerge.
These steps cover Google Sheets in a web browser on a computer (Windows, Mac, or Chromebook) and the Google Sheets app for Android, iPhone, and iPad. The app has fewer merge choices, so it has its own section below.
Google lists merging among the formatting tools on its Edit & format a spreadsheet help page.
Before You Merge
- You need edit access. If the file was shared with you as view-only or comment-only, the merge options are unavailable. Ask the owner for edit access, or use File > Make a copy and work in your copy.
- Only one value survives. A merged cell keeps the value from the upper-left cell of the selection. Text and numbers in the other cells are deleted. If you need them, combine them first (see “How to Merge Cells Without Losing Data” below).
- Merge for layout, not for data. Merging works well for a title across the top of a sheet or a label over a group of columns. Inside a table you plan to sort, filter, or total, it causes problems.
How to Merge Cells in Google Sheets
- Select the cells you want to combine. Drag across them, or click the first cell, hold Shift, and click the last one. The selection must be one connected block.
- Click Format in the menu bar at the top.
- Point to Merge cells. A submenu opens.
- Choose Merge all, Merge horizontally, or Merge vertically. The next section explains the difference.
- If more than one selected cell has data, Sheets shows a warning that only the upper-left value will be kept. Click OK to merge or Cancel to stop and keep your data.
The selected cells now act as one larger cell. When you click it, one border surrounds the whole block, and its address is the upper-left cell of the original range.
A merged cell also gives a picture more space after you insert a picture in a Google Sheets cell.
If you need room for a merged title above your data, insert a row in Google Sheets first.

Merging doesn’t center the text. Text stays on the left and numbers stay on the right, as they were. To center a title, click the merged cell, click the Horizontal align button in the toolbar, and choose Center. The Vertical align button next to it moves text to the middle of a tall merged cell.
Use the toolbar button
The Merge cells button sits in the toolbar near the borders and alignment buttons. Clicking the button itself merges the whole selection, the same as Merge all. Click the small arrow beside it to pick Merge horizontally, Merge vertically, or Unmerge instead. If the button looks faded, select more than one cell first.
Merge Options Explained
| Option | What it does | Example with A1:C3 selected | Good for |
|---|---|---|---|
| Merge all | Turns the whole selection into one cell | One cell covering nine cells | A sheet title or a single large label |
| Merge horizontally | Merges each row of the selection separately | Three wide cells, one per row | Section labels stacked down a sheet |
| Merge vertically | Merges each column of the selection separately | Three tall cells, one per column | A category label beside several rows |
With a single row selected, Merge horizontally gives the same result as Merge all. With a single column selected, Merge vertically does. Choosing Merge vertically on one row has nothing to combine, so it isn’t useful there.
Excel offers a similar set of choices under different names, which we cover in how to merge cells in Excel.
How to Unmerge Cells
- Click the merged cell. To unmerge several merged blocks at once, select a range that includes all of them.
- Click Format > Merge cells.
- Choose Unmerge. You can also click the merged cell and click the Merge cells toolbar button again.
The cell splits back into separate cells. The content stays in the upper-left cell, and the others are empty.
Unmerging doesn’t reset fonts, colors or borders, so if you want a plain look again, clear the formatting in Google Sheets as well.
Unmerge does not bring back values that the merge deleted. If you merged by mistake, press Ctrl + Z (Command + Z on a Mac) or click the Undo arrow in the toolbar right away. If it’s too late for Undo, open File > Version history > See version history (or click the version history icon at the top right), pick a version from before the merge, and click Restore this version. The steps are on Google’s version history help page.
To remove every merge on a tab, click the empty box above row 1 and to the left of column A to select the whole sheet, then choose Format > Merge cells > Unmerge. This affects only the tab you have open.
How to Merge Cells Without Losing Data
Because merging keeps only the upper-left value, combine the text into one cell first:
- Click an empty cell outside the range.
- Type a formula that joins the values.
=TEXTJOIN(", ", TRUE, A1:C1)puts a comma and a space between each value and skips blank cells.=A1 & " " & B1joins two cells with a space. To stack the values on separate lines, use=TEXTJOIN(CHAR(10), TRUE, A1:A3). - Press Enter, then copy the formula cell with Ctrl + C (Command + C on a Mac).
- Click the upper-left cell of the range you plan to merge and press Ctrl + Shift + V (Command + Shift + V on a Mac). This pastes the combined text as a plain value, so it won’t break when the original cells are cleared. You can also right-click and choose Paste special > Values only.
- Select the range and merge it. Click OK when Sheets warns that the other values will be discarded, since they’re already in the upper-left cell.
- Delete the helper formula cell.

If you only need the combined text and not a bigger cell, skip the merge and keep the formula. It updates on its own whenever the source cells change.
How to Merge Cells in the Sheets App
- Open the spreadsheet in the Google Sheets app.
- Tap a cell, then drag the blue markers to select the cells you want to merge.
- Tap Format (the icon of the letter A with lines).
- Open the Cell tab.
- Turn on Merge cells. The selection becomes one cell.
- Tap the sheet to close the panel and save the change.
The app merges the whole selection, the same as Merge all. It doesn’t offer the horizontal or vertical choices, so use a computer for those. To unmerge in the app, select the merged cell, open Format > Cell, and turn Merge cells off. Tap Undo at the top of the screen right away if a merge removed something you needed. The Merge cells option is on the Cell tab, as shown in Google’s Sheets app formatting steps.
When Merging Causes Problems
- Sorting fails. Sheets shows an error when you try to sort a range that contains merged cells. Unmerge the range, sort it, then merge any title cells again outside the data.
- You can’t create a filter. Merged cells in the data range can stop Data > Create a filter from working. Unmerge them and try again.
- Formulas skip values. Only the upper-left cell of a merged block holds a value, and the rest count as empty. A
SUMIForVLOOKUPthat expects a label on every row can miss rows covered by a vertical merge. - Merging across a frozen line is blocked. If rows or columns are frozen, you can’t merge cells that sit on both sides of the frozen line. Change the freeze or pick cells on one side. You can adjust it with the steps to freeze rows and columns in Google Sheets.
- Copying brings the merge along. Copying a merged cell pastes another merged cell. Paste with Ctrl + Shift + V if you only want the content.
- The merge options are grayed out. Check that you have edit access, that more than one cell is selected, and that the selection is a single rectangle. The range may also be protected; the owner can change that under Data > Protect sheets and ranges. Unmerge stays grayed out until the selection includes a merged cell.
If Create a filter is still grayed out after you unmerge, check the other causes in creating a filter in Google Sheets.
Alternatives to Merging
Merging is often used to make a long heading fit or stand out. These options do that without the side effects:
- Wrap the text. Select the heading cell and choose Format > Wrapping > Wrap so a long label fits inside its own column. Read more about wrapping text in Google Sheets.
- Freeze the header row. View > Freeze > 1 row keeps headings on screen while you scroll, without merging anything.
- Use the chart title. If the merged cell was only there to label a chart, add the label in the chart editor’s title field instead.
Merging Cells in Sheets Questions
Is there a keyboard shortcut to merge cells?
Google doesn’t list a dedicated merge shortcut, but you can reach the menu from the keyboard. Press Alt + O in Chrome on Windows or a Chromebook (Alt + Shift + O in other Windows browsers, or Ctrl + Option + O on a Mac) to open the Format menu. Then use the arrow keys to reach Merge cells, open the submenu, and press Enter on the option you want. The full set of menu shortcuts is on the Google Sheets keyboard shortcuts page.
Why can’t I merge cells?
The usual causes are view-only or comment-only access, a protected range, a selection that isn’t one connected block, or a selection that crosses a frozen row or column. The “When Merging Causes Problems” section above covers each fix.
Does unmerging restore the text I lost?
No. Unmerge only splits the cell, and the remaining value stays in the upper-left cell. Use Undo right after the merge, or restore an earlier copy from File > Version history.
How can I tell whether cells are merged or the text is just spilling over?
Click the cell. A merged cell is selected as one block with a single border around all of it. Text that spills into empty neighboring cells only selects the one cell it was typed in, and the spill stops as soon as you type something in the next cell.
Can I merge cells in Google Sheets on my phone?
Yes. Select the cells, tap Format, open the Cell tab, and turn on Merge cells. The app only does a full merge; for horizontal or vertical merges, use Sheets in a browser.
Once your title row is merged and centered, freezing it keeps it in view while you scroll through the data below.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.