Google Sheets Merge Cells: How It Works

Yes. Google Sheets lets you merge adjacent cells in a web browser: select the cells, then choose Format > Merge cells and pick a merge option. Google Sheets is Google’s spreadsheet app, not Microsoft Excel; Excel has a similar feature, but its menus and some behavior differ.

What merging cells means in Google Sheets

Merging combines two or more neighboring cells into one larger cell. It is mainly a layout tool: for example, you can merge cells across the top of a report to create a heading centered over several columns. The merged cell spans the space those cells previously occupied, but the worksheet’s rows and columns remain in place.

A common example is a table with monthly figures in columns B through D. You might put Quarterly results in B1, merge B1:D1, and format that area as a heading. The data rows below remain separate cells, so each month can still have its own value. Merging a heading is different from joining text: it does not combine the contents of several cells into one sentence.

Use merging sparingly in working data. A range with one cell per record and consistent columns is easier to sort, filter, copy, and use in formulas than a range containing merged cells. For ordinary tables, keeping cells separate and applying alignment or borders usually preserves more flexibility.

How to merge cells in a browser

In Google Sheets on a computer, select a rectangular group of adjacent cells. Then open Format > Merge cells and choose the option that matches the selection. You can also use the merge control on the toolbar; its dropdown provides the available merge choices. The options may be unavailable when the selection is not suitable for merging.

Open the spreadsheet and select the cells you want to combine. For a heading spanning three columns, select a range such as B1:D1.
Choose Format > Merge cells.
Select Merge all, Merge horizontally, or Merge vertically, as appropriate.
Check the displayed result, then adjust alignment, text wrapping, row height, or column width if needed.

To reverse the layout, select the merged cell and choose Format > Merge cells > Unmerge. Unmerging restores the individual cells, but it does not restore values that were discarded when the cells were first merged. If you are changing a shared or important sheet, consider making a copy first or undoing immediately if the result is not what you expected.

There is no need to change the spreadsheet’s file type to use this feature in Google Sheets. If you are editing an Excel workbook in Sheets, however, check the layout after making changes and again after exporting or reopening it in Excel; formatting can differ between spreadsheet applications.

What the merge options do

Google Sheets offers options for merging a selection in different directions. The option you choose affects how a multirow or multicolumn selection is grouped, so look at the range before confirming.

Merge all combines the selected cells into one cell. This is the usual choice for a heading spanning both rows and columns.
Merge horizontally merges cells across each selected row. If you select B1:D2, the result is one merged area for B1:D1 and another for B2:D2.
Merge vertically merges cells down each selected column. With B1:C3 selected, the cells in column B form one vertical merged area, and those in column C form another.
Unmerge removes the merged layout and returns the range to separate cells.

For a single-row heading, Merge horizontally and Merge all can produce the same visible result. For selections spanning several rows and columns, they are not interchangeable. If your goal is one large block, choose Merge all; if you want separate merged areas by row or column, choose the directional option.

What happens to existing cell contents

Merging is not a safe way to gather several existing values. When a selected range contains multiple entries, Google Sheets keeps the value from the upper-left cell and removes the other cell contents from the merged range. It may show a warning before completing the action. Read that warning rather than assuming that every value will remain visible in the new cell.

For example, if B1 contains North, C1 contains Central, and D1 contains South, merging B1:D1 does not create North Central South. The upper-left value, North, is retained; the other entries are discarded from those cells. If those labels matter, cancel the merge and combine or move the data another way before changing the layout.

To preserve several pieces of text in one cell, use a formula or edit a cell to join the text first, then merge only if a merged layout is still useful. Another option is to leave the cells separate and use a heading in a dedicated row. Keeping the original values in a backup range is sensible before any destructive layout change.

Formatting a merged heading

Merging changes the shape of a cell, not the text’s visual style. After merging, use the toolbar to set horizontal alignment, vertical alignment, font, fill color, and borders. For a title across several columns, center alignment is common. If the text is long, enable text wrapping or widen the columns; a merged cell does not automatically make all text visible.

Row height and column width still control the available space. A heading that wraps may need a taller row. If the merged area looks unexpectedly narrow, check the width of the columns it spans and the zoom level. Formatting can also be applied before merging, but it is often easier to select the finished merged cell and adjust its appearance afterward.

For a cleaner report that must remain easy to edit, consider centering text across separate cells without merging. Google Sheets alignment options can change where text appears, while preserving the underlying grid. This is useful when other people need to sort or modify the same range later.

Common problems and practical limits

The most important risk is losing values other than the upper-left entry. A second common problem is trying to merge a range that is not a simple adjacent rectangle. Select the exact block you intend to format, and avoid selecting scattered cells or including data rows by mistake. If a menu choice is unavailable, recheck the selection and whether part of it is already merged.

Merged cells can also make spreadsheet operations awkward. Sorting a table with merged areas may produce errors or a confusing result, and filters, copy-and-paste, or selecting a consistent range can be harder to manage. Exact behavior depends on the operation and layout, but merged cells are generally a poor fit inside the body of a sortable data table. Keep merges in titles, section labels, or presentation areas rather than across records.

Copying a merged area into a differently sized destination can cause a size mismatch or alter the pasted layout. If that happens, unmerge the source or destination as needed, paste into a matching range, or use Paste special options when you only need values or formatting. Before sharing a sheet, check it at normal zoom and make sure people can identify which rows and columns contain the actual data.

For accessibility and maintenance, a clear heading structure matters more than a decorative wide cell. Merging does not create a semantic heading for assistive technology; it changes the cell layout. Use descriptive text, sensible row and column labels, and consistent formatting so readers can understand the sheet even if they do not rely on visual styling alone.

Alternatives to merging cells

Before merging, decide whether you need a visual heading or genuinely need one cell. If you only want text to appear centered over a group of columns, leaving the cells separate can avoid problems with sorting and editing. Other alternatives are useful in different situations:

Center alignment: Align a heading within its own cell, or use available alignment settings to improve its appearance without combining cells.
Wrap text: Keep a long label in one cell and let it display on multiple lines, rather than merging across neighboring columns.
Insert a heading row: Put a title above the data table so it does not interfere with sorting the records below.
Join text deliberately: If the goal is to combine labels or values, use an appropriate formula or edit the text in a separate cell. Merging itself does not concatenate contents.
Use borders and fill: Apply a background color or border across a range to make a section stand out while leaving each cell independent.

These approaches are particularly helpful for shared sheets, inventories, schedules, and exports that will be analyzed later. A spreadsheet can look organized without sacrificing the rectangular structure that makes rows and columns useful.

Google Sheets and Excel: the difference

Google Sheets and Microsoft Excel both support merged cells, but they are separate applications. This article’s menu path is for Google Sheets in a web browser. In Excel for Microsoft 365 on Windows, select the cells and use Home > Merge & Center, or open the button’s dropdown for other merge choices. Excel’s command names and interface are not the Google Sheets menu path.

In either application, merging is primarily a formatting choice and can create difficulties in data ranges. If a workbook moves between Excel and Sheets, inspect the merged areas after opening it in the other program. Also verify that sorting, printing, and alignment look right; similar features do not guarantee identical behavior in every layout or file.

Frequently Asked Questions

Can you merge cells in Google Sheets?
Yes. Select adjacent cells, then choose Format > Merge cells and select Merge all, Merge horizontally, or Merge vertically. Use Unmerge in the same menu to separate a merged range.

How do I merge cells without losing data in Google Sheets?
Do not merge cells containing multiple values and expect them all to remain. Move or combine the information into a separate cell first, or keep the cells unmerged. Google Sheets retains the upper-left cell’s value when the range is merged.

Can I merge cells across multiple rows in Google Sheets?
Yes. Select the rectangular range and choose Merge all to create one merged area, or Merge vertically to merge each selected column separately. Check the selection carefully before applying the command.

How do I unmerge cells in Google Sheets?
Select the merged cell and choose Format > Merge cells > Unmerge. The cells become separate again, but values removed during the original merge are not restored by unmerging.

Why is Merge cells unavailable in Google Sheets?
Check that you selected adjacent cells in a suitable rectangular range and that the selection is not already merged in a way that prevents the requested operation. Try selecting the intended range again, then reopen Format > Merge cells.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.