Google Sheets Merge Cells Shortcut and Other Methods

Google Sheets has no dedicated default keyboard shortcut that merges cells directly. In a browser, press Alt+/ on Windows or ChromeOS, or Option+/ on Mac, search for “Merge cells,” and choose the command you need; you can also use Format > Merge cells.

The quickest way to merge cells

The keyboard route uses Google Sheets’ menu search, sometimes called the Tool finder. It is a useful shortcut to the command, but it is not the same as a key combination that immediately merges a selected range. The search route also helps if you cannot remember which menu contains the command.

Select the cells you want to combine. The selection should be a rectangular range, such as A1:C1 or A1:A3.
Press Alt+/ in a Windows or ChromeOS browser, or Option+/ on a Mac.
Type Merge cells in the menu search box.
Choose the appropriate merge command from the results, such as Merge all, Merge horizontally, or Merge vertically.

If the search results do not make it clear which kind of merge you want, open the menu directly: select Format > Merge cells, then choose the option from its submenu. The menu route is often easier when you want to inspect the available choices before acting. On some browser and keyboard setups, the search shortcut may be affected by the browser’s own shortcuts or keyboard layout; the Format menu remains a reliable alternative.

What the merge options do

Google Sheets offers several ways to merge a selected range. The right choice depends on the layout, not just on how many cells are highlighted:

Merge all combines the selected cells into one larger cell. For a selection spanning several rows and columns, the whole rectangle becomes one cell.
Merge horizontally merges cells across each row of the selection. For example, selecting A1:C2 creates one merged cell across A1:C1 and another across A2:C2.
Merge vertically merges cells down each column of the selection. Selecting A1:B3 creates one merged cell in column A and one in column B.
Unmerge separates a previously merged range back into individual cells.

For a title that should span three columns in a single row, select A1:C1 and use Merge all or Merge horizontally; both produce one merged cell in this one-row example. For a label that should cover several rows in one column, select A1:A3 and use Merge all or Merge vertically. When a selection has multiple rows and columns, the horizontal and vertical options create separate merged groups rather than one cell across the entire selection.

How to merge from the Format menu

The menu method is straightforward and makes the different merge behaviors visible. It is especially useful when you are working in a shared sheet, using an unfamiliar device, or making a change that you want to double-check before applying.

Click the first cell, then drag across the range, or click the first cell and Shift-click the last cell.
Check the highlighted range. A mistake in the selection can merge more cells than intended.
Choose Format > Merge cells.
Select Merge all, Merge horizontally, or Merge vertically.
Check the result and confirm the visible text and alignment are what you intended.

You can also select cells using the name box to the left of the formula bar: enter a range such as A1:C1, press Enter, and then use the Format menu. That can be more precise than dragging across a large sheet. If you have a range that is already merged, the menu may offer Unmerge rather than the merge choices. Use that command to restore the separate cells.

What happens to data when cells are merged

Before merging, check every cell in the selection for content. When a merge combines cells that contain multiple values, Google Sheets keeps the value in the upper-left cell and discards the contents of the other cells in the merged range. Treat the warning as important: merging is a layout operation, not a way to combine text or preserve a list of values.

For example, if A1 contains “Quarterly sales” and B1 contains “2026,” merging A1:B1 does not join those two phrases. The upper-left value remains, while the other cell’s value is lost from the merged range. If both pieces of information matter, combine them in a separate cell or otherwise preserve them before merging. You could copy the values elsewhere, or use a formula to join text in a separate cell; merging itself does not concatenate content.

After a merge, the merged value is associated with the upper-left cell of the range. The other cells are no longer independent cells for that merged area. This matters when formulas, sorting, filtering, copying, or later edits depend on a regular grid. If you are unsure whether you will need the original data, make a copy of the sheet or preserve the values in another range before changing the layout.

When merging cells makes sense

Merging is most useful for presentation: for example, a report heading spanning the columns beneath it, or a clear section label in a designed form. A merged heading can make the relationship between a title and a group of columns visually obvious. It can also simplify a printed or shared summary where the cells are primarily being read rather than manipulated.

It is usually a poor fit for the body of a data table. A well-structured table generally keeps one value per cell and one record per row. Merged cells interrupt that regular structure, which can make operations such as sorting and filtering harder to use and can create awkward selections when you paste, fill, or edit ranges. For instance, merging cells in the middle of a table to show a category across several records may look tidy, but repeating the category in each row is usually more practical for analysis.

A useful rule is to keep merged cells in headings, labels, and presentation areas, and keep the underlying data grid unmerged. If a sheet will feed a chart, pivot table, or another analysis, preserve a clean source range and put any decorative merged title outside it.

Common problems and how to fix them

The shortcut does not open menu search. Try the Format menu instead. Check that the Sheets tab has focus and that your browser or operating system has not intercepted the key combination. On Mac, the menu-search key is Option+/ rather than Alt+/.
The merge command is unavailable. Confirm that you selected more than one cell and that the selection is a rectangular range. If the cells are already merged, choose Unmerge from the same menu. In a protected sheet, your editing permissions may also restrict changes.
Some text disappeared. The merge kept the upper-left cell’s value and removed other values in the selected range. Use Undo immediately if the action was just made and you need to restore the prior state; otherwise, check version history or a saved copy where available.
The merged title is not centered. Merging and text alignment are separate settings. Select the merged cell and use the horizontal alignment control on the toolbar to choose the alignment you want.
Sorting or filtering behaves awkwardly. Unmerge cells within the data area and, where appropriate, repeat labels in each row. Keep decorative headings outside the range you sort or filter.

Undo can reverse a recent merge, but it is safest not to rely on it as a data-recovery plan. If other edits have happened since the merge, undoing may also reverse those edits. For important sheets, preserve a copy before making broad formatting changes.

Alternatives to merging

If the goal is visual clarity rather than creating a single larger cell, consider alternatives that keep the grid intact. You can apply a background color or border to a range, format a heading in bold, adjust column widths, or place a title in one cell and use wrapping or alignment to make it readable. These approaches preserve separate cells, which is valuable when the range contains data that may later be sorted, filtered, copied, or analyzed.

For a heading above a table, one simple design is to put the heading in the first column, leave the rest of that row empty, and apply a fill color or bottom border across the full heading range. The label remains in one ordinary cell, while the colored row still reads as a section title. Another option is to widen the first column or wrap the heading text instead of stretching it across several columns.

Excel users may recognize similar merge commands, but this article’s shortcut and menu paths are for Google Sheets in a web browser. Excel has its own ribbon and keyboard behavior, so do not assume that a Sheets menu-search shortcut or its exact sequence works the same way in Excel. In Sheets, use Format > Merge cells when you want the explicit, program-specific route.

Frequently Asked Questions

Is there a direct keyboard shortcut to merge cells in Google Sheets?

Google Sheets does not provide a dedicated default shortcut that immediately merges the selected cells. Use Alt+/ on Windows or ChromeOS, or Option+/ on Mac, to search menus for Merge cells, or choose Format > Merge cells.

What is the shortcut for merging cells on a Mac?

In Google Sheets in a browser, press Option+/ to open menu search, then search for Merge cells and choose the desired command. If that key combination is unavailable on your keyboard or is intercepted, use Format > Merge cells.

Will merging cells combine their text?

No. Merging is not a text-joining feature. When multiple selected cells contain values, Sheets keeps the upper-left value and discards the other contents in the merged range. Preserve or combine the information separately before merging.

How do I unmerge cells in Google Sheets?

Select the merged cell or range, then choose Format > Merge cells > Unmerge. The cells become separate again, but unmerging does not recreate values that were discarded when the cells were originally merged.

Can merged cells cause problems with sorting?

They can make a data range harder to sort or filter because the cells no longer form a regular grid. Keep merged cells in presentation headings rather than the records themselves, and use repeated labels in data rows when those labels need to be sorted or analyzed.

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.