Merge or Unmerge Cells in Google Sheets? Choose Well

In Google Sheets, select the cells, then choose Format > Merge cells and pick a merge option; to reverse it, select the merged cell and choose Format > Merge cells > Unmerge. Merge cells mainly to format a visual heading or label—not to organize ordinary table data—because merging can discard values and make sorting or filtering harder.

What merging cells does

Merging combines two or more adjacent cells into one larger cell on the sheet. The merged area looks like a single space for entering and displaying content, and only its upper-left cell remains the cell that holds the content. For example, merging A1 through C1 makes one wide cell spanning those columns; it does not create three separate cells that happen to share a label.

That distinction matters when you later reference or edit the area. A formula or other operation cannot treat every part of a merged area as an independent cell while the merge remains in place. The top-left cell is the meaningful location for the merged cell’s value. The other positions are incorporated into the merged area, rather than remaining empty, separately addressable cells.

Merging changes the sheet’s layout, not the meaning of the information. It does not combine several entries into a sentence, add values together, or preserve multiple cell contents in a hidden list. If you need to join text from several cells, use a formula or edit the text in a regular cell instead of merging them.

How to merge cells in a browser

In the Google Sheets web app, the menu path is the clearest way to choose the kind of merge you want:

Select a rectangular range of adjacent cells by dragging across the cells, or click the first cell and Shift-click the last cell.
Open Format > Merge cells.
Choose Merge all, Merge horizontally, or Merge vertically, depending on the layout you need.
Check the result and make sure the value you intended to keep is still visible in the merged area.

Sheets may warn that merging keeps only the upper-left cell’s contents. Read that warning before confirming. If the cells contain information you need, cancel the operation and copy or move the entries somewhere safe first. You can also use the merge control on the toolbar when it is visible, but the Format menu makes the available options explicit.

The selected cells need to form a suitable adjacent rectangle. You cannot merge a scattered selection into one cell. If the merge command is unavailable or the result is not what you expected, check that the selection is contiguous and that you have permission to edit the sheet.

Choosing among the merge options

Merge all combines the entire selected rectangle into one cell. If you select B2 through E2, the result is a single cell spanning four columns. This is useful for a title that should sit above a group of columns, such as “Quarterly Results” above January through March.

Merge horizontally merges cells across columns, row by row. If you select A1:C3, Sheets makes a separate horizontal merged cell for each row: A1:C1, A2:C2, and A3:C3. This can suit repeated labels across a layout, but it is not the same as making one large merged cell across the whole selection. For each horizontal group, the leftmost cell is the one whose contents are retained.

Merge vertically merges cells down rows, column by column. Selecting A1:C3 produces one vertical merged area in each column. The topmost cell in each vertical group supplies the retained content. Consider this option only when the repeated rows are meant to share one label, such as a category label beside a visually grouped block.

In all cases, merging is not a way to preserve every value. If you are unsure which cells contain data, inspect the range first or make a copy of the sheet. The choice of merge direction determines the shape of the resulting area, but it does not turn discarded cell contents into recoverable parts of that area.

When merging is useful—and when it is not

A merge can help make a report or presentation-style sheet easier to scan. A heading spanning several columns gives a visual cue that those columns belong together. A form may also use a merged area to provide a wider space for an instruction or a prominent label. These are layout goals, where appearance matters more than treating each position as a data field.

For instance, a small report might have “Monthly sign-ups” centered over columns labeled January, February, and March. Merging the heading cells can make that relationship obvious. Keep the month labels in their own unmerged cells below it, however; each column needs its own label if readers or sheet features are to interpret the data clearly.

Avoid merging within a normal data table. A useful table usually has one record per row and one field per column, with a distinct header for every column. Merged cells interrupt that regular structure. Sorting, filtering, copying ranges, and extending the table can become confusing or may not work as expected when a selected range includes merged areas. A merged header across several columns is especially unhelpful if each column represents a different field.

Good candidate: a decorative title above a report, separate from the sortable data.
Poor candidate: a customer, date, or status column in a table that people need to sort and filter.
Good candidate: a form layout where a wide blank area is intentionally one input space.
Poor candidate: several values that need to remain independently editable, referenced, or exported.

What happens to data and formatting

The key risk is content loss. When a range has entries in more than one cell, Sheets retains the content of the upper-left cell of a full merge and removes the other contents in the selected area. For a horizontal merge, think of the leftmost cell in each row as the one kept; for a vertical merge, think of the topmost cell in each column. Do not assume that numbers, text, or formulas from the other cells will be joined together automatically.

Suppose A1 contains “North” and B1 contains “South.” Merging A1:B1 will not produce “North South.” The retained value is “North,” and the other entry is lost from the merged range. If both names matter, first place them in separate cells or combine them deliberately in an unmerged cell, then decide whether a merge is still appropriate.

Formatting is separate from content. Text alignment, borders, fill color, and wrapping affect how the merged area appears, but they do not restore discarded entries or make the cells independently usable. After a merge, review alignment and text wrapping; a long heading may need horizontal alignment or wrapping adjusted to display cleanly. Do not confuse centering text with merging: the alignment controls can center content without changing the cell structure.

How to unmerge cells

To undo a merge while keeping the current contents, select the merged area and choose Format > Merge cells > Unmerge. The previously combined positions become separate cells again. The value currently in the merged area remains in its original top-left position, while the other positions are blank; unmerging does not reconstruct the values removed when the merge was made.

If you just merged the cells and want to reverse the action immediately, use Undo: Ctrl+Z on Windows or Command+Z on Mac. Undo is usually the simplest way to reverse the recent change, including its effects on content. If other edits have happened since, undoing may also reverse those later edits, so check the sheet before using it repeatedly.

For an older change, open File > Version history > See version history to review earlier saved versions. Restoring a prior version can affect other edits made after that version, not just the merge. Before restoring, consider making a copy of the current sheet or checking whether the missing information remains in an earlier version. If the lost values were never saved elsewhere and the relevant prior version is unavailable, unmerge alone cannot recover them.

Common problems and practical fixes

If a merge seems to have erased information, stop editing the range and use Undo promptly if the merge is the most recent change. Otherwise, check version history or a backup. Unmerging only separates the area; it does not bring back the overwritten or removed contents. This is why checking every cell before a merge is more reliable than treating unmerge as a safety net.

If sorting or filtering behaves unexpectedly, look for merged cells in the data range, particularly in the header row. Keep the underlying table rectangular and unmerged, with one header per column. Move decorative headings above the table and outside the range you sort or filter. If you share the sheet with others, explain which cells are intended as layout and which are actual data fields.

If a heading looks off-center after merging, select the merged cell and use the horizontal alignment controls on the toolbar. Merging does not automatically guarantee the visual alignment you want in every layout. Check vertical alignment and text wrapping as well, especially if the merged area is tall or contains more than a short label.

If only some rows should share a label, avoid selecting a larger block than intended. Use the specific rows or columns that belong together and confirm whether Merge horizontally or Merge vertically matches the desired shape. A mistaken selection can create several merges at once, which may be harder to work with than one deliberately chosen merge.

Alternatives to merging

For a centered heading across several columns, first ask whether the appearance requires a true merge. You can leave the cells separate, place the heading in one cell, and adjust alignment or column widths. Keeping the cells separate preserves the sheet’s regular grid and reduces conflicts with data entry and sorting. Google Sheets does not need a merge merely because text should look prominent or centered in a layout.

For a table label that applies to multiple rows, repeat the label in every row or use a consistent category column. Repeating a value may look less compact, but it is easier to filter, sort, analyze, and export. For several pieces of text that need to appear together, combine them explicitly in a regular cell rather than expecting a merge to concatenate them.

Excel has a similar merge concept, but its commands are located on the Home tab in the Merge & Center control. The instructions above use Google Sheets’ browser menus; do not follow Excel ribbon directions when working in Sheets. In either program, the structural trade-off is similar: merged cells can improve presentation, but keeping data in separate, consistently organized cells is generally more flexible.

Frequently Asked Questions

Does merging cells in Google Sheets delete data?
It can. In a merge, Sheets retains the content from the relevant top-left cell (or the first cell in each horizontal or vertical merge group) and discards other contents in that group. Copy values elsewhere before merging if you need them.

Can I unmerge cells and get the original values back?
No. Unmerge restores separate cell positions, but it does not restore contents removed during the merge. Use Undo immediately after the merge or look for an earlier version in version history.

How do I merge cells without losing data?
First move or copy every value you need to keep outside the range, or combine the information deliberately in a separate cell. Then merge only when one retained value is appropriate for the resulting area.

Can I merge cells in a Google Sheets table and still sort it?
Merged cells in a data range can interfere with sorting and filtering. For a reliable table, keep each row and column as a separate field and put any merged decorative heading outside the range being sorted or filtered.

What is the difference between Merge all and Merge horizontally?
Merge all makes the selected rectangle one merged cell. Merge horizontally makes a separate left-to-right merged cell on each row of the selection. Merge vertically instead makes separate top-to-bottom merged cells in each column.

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.