To merge cells in Google Sheets, select the adjoining cells, then choose Format > Merge cells and pick a merge option. Before you do, check for content in every selected cell: a merge keeps the content from the appropriate starting cell and removes content from the others. Merging changes the layout, not the way Sheets combines text or calculates data.
What You’ll Need
- A Google account with access to the spreadsheet, and a web browser with the sheet open.
- Two or more adjoining cells you want to make into one larger cell. They can be arranged in a rectangle, a row, or a column.
- A quick check of the selected cells for values, formulas, or other content you need to keep. Copy important content elsewhere before merging.
The instructions below are for Google Sheets in a desktop web browser. The Google Sheets mobile apps have a different layout. Excel is a separate program: its merge controls are on the Home tab, not under Google Sheets’ Format menu.
Step-by-Step
- Open the spreadsheet and choose the right sheet. Go to Google Sheets, open your file, and click the worksheet tab that contains the cells. If the file is shared, make sure you have permission to edit it; view-only access will not let you change the layout. Consider making a copy first if the sheet contains important information or is used by other people.
- Decide what you want the merged area to look like. Use a single merged cell for a heading spanning several columns, a horizontal merge for a label spanning cells on one row, or a vertical merge for a label spanning cells in one column. Choosing the shape first helps prevent accidentally merging a whole block when you only meant to join one row.
- Select the adjoining cells. Click the first cell, then drag across the cells to include. You can also click the first cell, hold Shift, and click the last cell in the range. For example, select B1 through E1 to make a header area across four columns. The selected range should be a solid rectangle; Google Sheets cannot merge scattered, nonadjacent cells into one cell.
- Check the contents before changing anything. Look through the highlighted cells, including cells that appear blank but may contain a formula or a space. For a merge of a single rectangle, the upper-left cell is the starting cell whose content is kept; content in other cells in that rectangle is discarded. If several cells contain useful text or numbers, copy them to a safe place or combine the information in a separate cell before merging.
- Open the merge options. In the menu bar, click Format > Merge cells. You can also use the merge-cells button on the toolbar and open its dropdown. If the toolbar button is not visible, use the Format menu instead. The options are Merge all, Merge horizontally, and Merge vertically; an Unmerge option appears when relevant.
- Choose the merge type that matches your selection. Choose Merge all to turn the selected rectangular range into one cell. Choose Merge horizontally to merge cells across each selected row, or Merge vertically to merge cells down each selected column. For horizontal merges, the leftmost cell in each row supplies the retained content. For vertical merges, the top cell in each column supplies it. Review the menu options before clicking because the result depends on both the selection and the option.
- Confirm the result and adjust alignment. Check that the merged area has the intended shape and that the expected content remains. Merging does not automatically center text. To center a heading, select the merged cell and use the horizontal alignment button on the toolbar, then choose Center. Use the vertical alignment control if you also want the text centered from top to bottom.
- Save and check the surrounding sheet. Google Sheets saves changes automatically, but pause to make sure nearby labels, borders, and formulas still make sense. If the result is wrong and you have not made other changes since, use Edit > Undo or Ctrl+Z on Windows and ChromeOS. On Mac, use Command+Z. Undo promptly; it reverses the most recent action, which may not be the merge if you have continued editing.
For a common heading example, select B1:E1, check that B1 contains the heading and C1:E1 do not contain information you need, then choose Format > Merge cells > Merge all. This creates one wider cell across those columns. If you instead select B1:E3 and choose Merge horizontally, Sheets creates one merged cell per row, not one cell across the entire three-row block. That distinction is useful when making repeated row labels.
Common Mistakes
- Assuming all the text will be joined together. Merging is not the same as combining values. In a single rectangular merge, Sheets retains the upper-left cell’s content and removes the other selected cells’ content. For horizontal or vertical merges, the retained starting cell is the leftmost cell in each row or the top cell in each column, respectively. Copy or combine content before merging if you need to keep it all.
- Selecting too many cells. A selection that includes extra rows or columns can create a larger merged area than intended. Check the highlighted range and its row and column labels before choosing a merge option.
- Expecting Merge all to act like Merge horizontally. Merge all creates one cell from the full selected rectangle. Merge horizontally creates separate merged cells for each row, while Merge vertically creates separate merged cells for each column. Use the option that matches the desired layout.
- Using merged cells in a data table. Merged cells can make sorting, filtering, copying, and filling a table harder to manage. Keep them for presentation areas such as titles and section headings, and use ordinary cells for records that need to be sorted or analyzed.
- Thinking merging also centers the text. The cells become one area, but text alignment is a separate setting. Set horizontal or vertical alignment afterward if the heading needs to sit in the middle.
Tips
- Use Merge horizontally for repeated row labels. If each row needs its own merged area, select the relevant block and merge horizontally. This is different from merging the whole block into one large cell, which would leave only one editable cell.
- Keep the original values when they matter. Copy the selected range to a temporary area or duplicate the sheet before merging. If several text values need to appear together, combine them in a separate cell first using an appropriate formula or manual editing, then merge only after confirming the combined result.
- Consider centering without merging. If your goal is simply to make a heading appear centered across columns, merging may not be necessary. Depending on your sheet and formatting needs, center alignment or other layout choices can avoid interfering with a table’s structure.
- Use borders and formatting deliberately. After merging, apply a border to the merged range if its outline needs to stand out. Set text wrapping if a long heading should fit on multiple lines, and adjust row height or column widths so the text remains visible.
- Plan for collaborators. Merged cells can surprise people who enter data into the sheet. Add a note or keep merged headings outside the area where collaborators add rows. In shared operational sheets, a clear, unmerged table is often easier for everyone to update.
- Remember that unmerging does not restore removed values. It returns the area to separate cells, but it cannot bring back content discarded during the merge. Use undo immediately or restore a prior version if you need to recover missing information.
Troubleshooting
The merge option is unavailable or greyed out. Confirm that you selected multiple adjoining cells and that you have editing permission. If the selection includes a complicated mix of existing merged and unmerged cells, first select and unmerge the existing merged area, then make a clean rectangular selection and try again. A protected sheet or protected range may also prevent editing; ask the owner to change your access or protection settings.
The cells merged in the wrong direction. Use Edit > Undo immediately, then select the intended range again. Check whether you want one merged rectangle, a merged area on every row, or one on every column. Choose Merge all, Merge horizontally, or Merge vertically to match. If you notice the error later, select the merged cells and choose Format > Merge cells > Unmerge, then reselect the correct range. Unmerging does not recover discarded cell contents.
Text or numbers disappeared. Undo the merge straight away if it is still the latest action. If you have already made other edits, open File > Version history > See version history to review earlier versions. Restoring a version can affect other edits made since then, so check the version carefully; you may prefer to copy the missing information from an earlier version instead of restoring the whole sheet.
The heading is not centered or is cut off. Select the merged cell and adjust horizontal and vertical alignment from the toolbar. If the text is too long for the available space, widen the columns, increase the row height, or enable text wrapping. Merging does not guarantee that all text will display in one line.
You are using a phone or tablet. The mobile app’s menus differ from the browser instructions. Select the cells, open the formatting controls (often shown as an A icon), and look under the cell-formatting options for Merge cells. If the control is hard to find or the selection is complex, open the file in a desktop browser and follow the Format menu path above.
Frequently Asked Questions
Does merging cells combine their contents?
No. Merging changes the cell layout; it does not join all selected values. In a full rectangular merge, the upper-left cell’s content remains, and content in the other cells is removed. Copy or combine anything you need to keep before merging.
Can I merge cells that are not next to each other?
No. The selected cells must form one adjoining rectangle, row, or column. If you need information from separate areas, bring it together in a new cell or arrange the cells into one continuous range first.
How do I undo or reverse a merge?
Use Edit > Undo right after merging, or select the merged cell and choose Format > Merge cells > Unmerge. Undo can restore the previous state if the merge is still the latest action; unmerge alone does not restore contents that were removed.
Can I merge cells in Google Sheets on a phone?
Yes, the Sheets app includes cell-formatting controls, but its interface differs between devices and app versions. Select the range, open formatting, and look for Merge cells. For the clearest menu labels and easiest range selection, use Sheets in a desktop browser.
Is merging in Google Sheets the same as in Excel?
The purpose is similar, but the menus differ. In Google Sheets, use Format > Merge cells or the toolbar. In Microsoft Excel for Microsoft 365 on Windows, the merge options are on Home > Merge & Center. Check Excel’s prompt about retaining data before proceeding; do not assume its menu path is available in Sheets.
Related
- Group and Ungroup in Excel with Keyboard Shortcuts
- Freeze X and Y Panes in Excel for the Web: Step-by-Step
- How to Freeze the Top Row in Excel While Scrolling
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: How to Copy Conditional Formatting RulesYes. In Google Sheets, copy a cell or range with the conditional formatting you want, select the destination,…
- How to Make a Work Schedule in Google Sheets: A GuideTo make a work schedule in Google Sheets, create a table with one shift per row, add columns…
- Excel Extract Text From the End of a String in 365To extract everything after the last delimiter in Excel for Microsoft 365, use =TEXTAFTER(A2,"-",-1) when the text is…
- How to Create Binder Labels in Word: A Step-by-Step GuideCreate binder labels in Word by choosing a label template that matches your label stock, entering the spine…
- Excel Freeze Panes: Repeat Rows on Every Printed PageNo: Excel’s Freeze Panes setting keeps rows or columns visible while you scroll, but it does not make…
- Outlook Form Templates: Create and Save OneTo create a reusable custom form in classic Outlook for Windows, enable the Developer tab, choose Developer >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.