Why Can’t I Merge Cells in Google Sheets?

Why Can't I Merge Cells in Google Sheets?

You usually can’t merge cells in Google Sheets because the selection is not one editable, continuous range, you lack permission to change it, or the cells belong to a protected or generated area such as a pivot table. In a browser, select a rectangular range and choose Format > Merge cells; if that command is unavailable, check the selection and access restrictions first.

Check the selection and the menu first

Start with a quick comparison: click one cell, then drag across a simple rectangle of two or more ordinary cells. Look at Format > Merge cells. If the command is active for the rectangle but not for your original selection, the issue is likely the shape or contents of that original selection rather than a missing feature.

One cell selected: There is nothing to merge, so the merge commands may be unavailable.
Cells selected in separate areas: A merge works on one contiguous rectangular range, not several disconnected selections at once.
Only some merge choices are active: The available choices can depend on whether the selection spans multiple rows, columns, or both.
Every merge choice is unavailable: Check whether you can edit the sheet, whether the range is protected, and whether it is part of a pivot table.

The toolbar’s merge button can also appear unavailable, but the menu is a useful cross-check. If both the toolbar and Format menu are disabled for a valid rectangle, changing browsers or repeatedly clicking the button is unlikely to solve a permission or range restriction.

What merging does in Google Sheets

Merging makes multiple neighboring cells behave like one larger cell. For example, merging A1 through C1 creates a single cell spanning three columns, which is often used for a heading above a small report. In the web version, choose Format > Merge cells and then select an available option, such as Merge all, Merge horizontally, or Merge vertically.

Those choices have different effects. Merge all combines the full selected rectangle into one cell. Merge horizontally combines cells across each selected row, while Merge vertically combines cells down each selected column. If you select a three-column-by-two-row block, for instance, Merge horizontally makes two merged cells, one per row; it does not make one large cell covering the entire block.

Merging changes the layout, not the underlying meaning of the data. It does not join the text or numbers from all the selected cells into a combined value, and it does not create a special heading field. That distinction explains both why merging is sometimes blocked and why it can cause trouble later when a sheet is sorted, filtered, or reused as a data table.

Editing permission and protected ranges

A viewer or commenter cannot change cell formatting, so they cannot merge cells. If the file is shared with you but the merge commands are disabled throughout the sheet, check whether you have Editor access. Ask the owner to change your sharing role if you need to make the change yourself; alternatively, the owner or another editor can perform the merge.

Editors can still be prevented from changing particular cells. A protected sheet or protected range may allow editing in some places while blocking it in others. If you can edit one area but not the cells you want to merge, protection is a strong possibility. Where available, review Data > Protect sheets and ranges, or ask the owner to inspect the protection settings and grant the required access. Do not assume that being an editor means every cell is editable.

There is an important difference between a disabled command and an edit warning. Sometimes Sheets lets you attempt an action but then says that the cells are protected or that you do not have permission. In that case, the warning identifies an access restriction; selecting the range again will not override it. Only someone with the appropriate access can change the protection or make the merge.

Selection shape and existing merged cells

The range must be one continuous rectangle. For example, A1:C1 is rectangular, but selecting A1 and C1 as separate cells with a modifier key is not a single rectangular range. Sheets cannot merge disconnected selections into one cell. Select the complete rectangle between the first and last cell instead, making sure you are not including an unrelated area by mistake.

Existing merged cells can make a new selection confusing. A selection that cuts through the edge of a merged cell, or combines merged and unmerged areas in an awkward way, may not offer the operation you expect. First inspect the area for existing merges. To undo one, select it and use Format > Merge cells > Unmerge. Then select the intended rectangle again. Unmerging restores the individual cells, but it does not restore values that were discarded when the cells were originally merged.

Also check whether you have selected entire rows or columns when you meant to select a small block. Selecting a bounded range such as B2:D2 is easier to diagnose and less likely to include headings, notes, or cells outside the layout you intended to change.

Pivot tables and other generated areas

Pivot tables are built from source data, and their displayed results are generated by Sheets. You generally cannot format or edit individual output cells as though they were ordinary cells, so merge commands may not be available for cells inside the pivot table. Make presentation changes outside the pivot table, or adjust the source data and pivot-table layout rather than trying to merge its result cells.

Similarly, consider whether the range is controlled by a feature or workflow that expects each cell to remain separate. A sheet used for sorting, filtering, importing, or maintaining a row-per-record dataset is usually better left unmerged. If the merge command works in a nearby blank area but not in the generated range, that contrast is a clue that the range itself—not your browser—is the obstacle.

If a file was originally created in Excel and opened in Google Sheets, first confirm that you are working in the intended file and that you have edit access. The usual Sheets browser menu is Format > Merge cells. Excel has its own merge controls and warnings, so instructions for Excel’s ribbon do not necessarily describe what you will see in Sheets.

Merge cells safely in the browser

When the range is editable and ordinary, these steps make the operation predictable:

Select the adjacent rectangular cells you want to combine, such as A1:C1.
Choose Format > Merge cells.
Choose Merge all, Merge horizontally, or Merge vertically according to the layout you want.
Check the result and confirm that the displayed content is the content you intended to keep.

If the command remains disabled, test a small rectangle elsewhere in the same sheet. If it works there, compare the original range for protection, existing merges, or generated cells. If it fails everywhere, verify that you are signed into the right account and have edit access. Reloading the page can help if the interface has become stale, but it will not remove a protection rule or change your sharing role.

Before making a large formatting change, consider keeping a copy or confirming that the sheet’s owner is comfortable with the change. This is especially sensible in a shared spreadsheet where other people depend on the layout or where the cells contain information that must be preserved.

What happens to the contents

Merging is not a way to combine the values in several cells. When a range contains more than one value, Sheets keeps the content in the upper-left cell and removes the contents of the other cells as part of the merge. For instance, if A1 contains North and B1 contains Region, merging A1:B1 does not produce North Region; the value from B1 is lost. Check the selected cells before confirming the operation.

If the goal is to combine text, combine the values first and put the result in one cell. With North in A1, Region in B1, and 2026 in C1, enter =TEXTJOIN(" ", TRUE, A1:C1) in D1; it returns North Region 2026. The formula creates a combined text value, while merging only changes the cell layout. You can then decide whether to keep the source cells, copy the result, or use it in a separate heading.

Merged cells can also complicate spreadsheet operations. Sorting a dataset with merged cells can produce unexpected layouts or be restricted, and merged headings inside a filtered list make it harder to keep each record aligned with its row. Screen readers and other accessibility tools may also make a complex merged layout harder to navigate. These are reasons to use merges sparingly in sheets that are meant to store or analyze data.

Alternatives when merging is not a good fit

For a decorative title, a merge can be reasonable if the surrounding cells are empty and the sheet is not being used as a sortable data table. For data itself, keep one value per cell and use a separate title row or a note above the table. That structure makes filtering, sorting, formulas, and later exports more dependable.

If the intention is to join text, use a formula such as TEXTJOIN rather than merging. If the intention is simply to make a heading stand out, try bold text, a fill color, borders, wrapping, or a larger row height. Center alignment can improve the appearance of text within its cell, but selecting several cells and centering does not turn their separate values into one centered heading across the whole selection.

The right choice depends on how the sheet will be used. A report designed mainly for reading may benefit from a few merged headings. A working list of customers, inventory, survey answers, or transactions usually benefits from unmerged cells, with a clear header in each column. Keeping presentation separate from data avoids having to undo layout decisions when the spreadsheet grows.

Frequently Asked Questions

Why is Merge cells greyed out in Google Sheets?
Usually, the selected range is not a single editable rectangle, you selected only one cell, or you do not have permission to edit the cells. Protected ranges and pivot-table output can also prevent changes. Try a simple rectangle in an ordinary editable area to narrow down the cause.

How do I merge cells in Google Sheets?
In a browser, select adjacent cells and choose Format > Merge cells, then select the merge style. Merge all creates one cell from the full rectangle; Merge horizontally or vertically combines cells in the corresponding direction.

Does merging cells combine their text?
No. Merging changes the layout and keeps the upper-left cell’s content; other selected cell contents are discarded. To join text, use a function such as TEXTJOIN or combine the text manually before merging.

Can I merge cells in a pivot table?
Pivot-table results are generated from source data and are not ordinary editable cells, so you generally cannot merge cells inside the output. Put a heading or other presentation element outside the pivot table instead.

Why can I merge some cells but not others?
The cells that work may be unprotected and editable, while the others may be protected, already merged, or part of generated output. Compare the two ranges and check the owner’s protection settings if you have editor access but still cannot change a particular area.

Will unmerging restore the values that disappeared?
No. Unmerging separates the cell layout again, but it does not recover content removed from the non-upper-left cells during the original merge. If those values matter, restore them from a version history entry or another copy of the data.

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.