Google Sheets Merge Cells Shortcut and Menu Options

Google Sheets does not have a dedicated keyboard shortcut that directly merges selected cells. In a browser, open the Tool finder with Alt+/ on Windows or ChromeOS, or Option+/ on Mac, search for “merge cells,” and choose the merge command you need; you can also use Format > Merge cells.

The quickest way to merge cells

The Tool finder is the closest thing to a merge-cells shortcut because it lets you find and run a Sheets command from the keyboard. First select the cells, then open the Tool finder and search for the command. Choose Merge all, Merge horizontally, or Merge vertically according to the layout you want. The available choice depends on the shape of the selection.

Select the adjacent cells you want to combine. For example, drag across A1:C1 to merge three cells in the first row.
Press Alt+/ on Windows or ChromeOS, or Option+/ on Mac.
Type merge cells in the Tool finder search field.
Select the appropriate merge option from the results.

This method avoids opening the menus with the mouse, but it is not a single direct shortcut: you still search for and choose the command. If the key combination does not open the Tool finder, use its search-menus control in the Sheets toolbar or go through Format > Merge cells. Browser and keyboard layouts can affect how shortcut keys are entered, so the menu path is a reliable fallback.

What the merge options do

Google Sheets offers different merge behaviors because a selected range can cover several columns, several rows, or both. The option you choose determines which cells become one larger cell. In the Format menu, open Merge cells to see the available commands.

Merge all: Combines the entire selected rectangular range into one cell. Selecting A1:C2, for example, makes one cell spanning three columns and two rows.
Merge horizontally: Merges cells across each row of the selection, keeping the rows separate. Selecting A1:C2 produces one merged cell across A1:C1 and another across A2:C2.
Merge vertically: Merges cells down each column, keeping the columns separate. Selecting A1:B3 produces a vertical merged cell in column A and another in column B.
Unmerge: Separates cells that were previously merged. It does not restore any contents discarded when the cells were merged.

For a selection that is only one row high, Merge horizontally is usually the relevant choice. For a selection that is only one column wide, Merge vertically is the matching option. If an option is unavailable or behaves differently from what you expected, check the dimensions of the selected range and choose a command suited to that shape.

What happens to the cell contents

Merging is a layout operation, not a way to combine text or values from several cells. When the selected cells contain multiple entries, Sheets keeps the value in the upper-left cell and removes the contents of the other cells in the merged range. Sheets may show a warning before proceeding. Treat that warning as important: unmerging later does not bring back the removed values.

For example, suppose A1 contains “North,” B1 contains “East,” and C1 contains “West.” If you merge A1:C1, only the upper-left entry, North, remains in the merged cell. East and West are not joined to it. If you need all three labels, move or combine the information before merging, or use a different layout that leaves the entries in separate cells.

To preserve the data, make a copy of the range or move the values elsewhere before merging. If your goal is to display a long heading across several columns without losing the underlying cell structure, consider centering the heading through formatting instead. That can give a similar visual effect while leaving each cell available for data.

When merging cells is useful

Merged cells are most useful for presentation: a report title above a small table, a section heading spanning several columns, or a label centered over a group of related columns. For example, a heading such as Quarterly sales could be placed in A1 and merged across A1:D1 to visually cover four quarter columns.

They are less suitable for the body of a data table. A table with merged cells may be harder to sort, filter, fill down, or reference consistently, because the merged area no longer behaves like a regular grid of independent cells. If each row represents a record, keep its fields in separate columns and use an ordinary heading row. This is usually clearer for people and easier for spreadsheet features to work with.

A useful rule is to merge for a clear visual heading, not to make ordinary records look grouped. If the same label needs to apply to multiple rows, repeating the label in each row or using a separate category column is often more practical than a tall merged cell.

Prepare a range before merging

A short check before running the command can prevent lost information and awkward layouts. Confirm that the cells are adjacent and that the selected range has the intended number of rows and columns. Then inspect the contents, including cells that may look blank but contain spaces or formulas.

Copy or record any non-empty values outside the upper-left cell if you need to keep them.
Check whether the range includes more rows or columns than intended; a selection error can create a much larger merged area.
Decide whether you want one large cell or separate merged cells in each row or column.
Consider sorting, filtering, formulas, and future data entry before merging cells inside a working table.
After merging, check alignment and text wrapping so the heading remains readable.

For a title over columns A through D, select only A1:D1 rather than selecting the entire table. For grouped row labels, think carefully before selecting a multirow range: Merge all would create one tall cell, while Merge vertically would create a separate merged cell for each selected column.

How to undo or unmerge

If you have just merged the wrong range, use Edit > Undo or the undo button in the toolbar to reverse the most recent action. Undo is generally the best option when the merge was accidental and you want to restore the earlier sheet state. As with other editing actions, later changes may mean you need to undo more than once to reach the merge operation, so check what each undo changes.

To separate a merged cell later, select it and choose Format > Merge cells > Unmerge. You can also use the Tool finder: open it with Alt+/ on Windows or ChromeOS, or Option+/ on Mac, search for unmerge, and select the command. Unmerging restores the individual cell grid, but it does not recover values that were discarded during the original merge. The remaining value is typically in the upper-left cell of the former range.

Common problems and misconceptions

The shortcut seems not to work: Alt+/ or Option+/ opens the Tool finder; it does not merge the cells by itself. Search for the command and select it. If the Tool finder does not open, use the Format menu path instead.

Only one value appears afterward: That is expected when a range contains multiple values. Merging keeps the upper-left value rather than concatenating entries. Undo immediately if the other contents matter, then preserve them before trying again.

The merge option is unavailable: Check that you selected a range of adjacent cells and that the command matches its shape. A single cell cannot be combined with neighboring cells unless those neighbors are also selected.

Text looks cut off: Merging changes the cell area but does not guarantee that all text will display on one line. Adjust alignment, column width, or text wrapping after the merge. Also remember that a merged heading can cover space that would otherwise show separate cell contents.

Merging is not the same as combining data: If you want text from multiple cells joined into one value, use a text-combination method or edit the destination cell instead of merging. A merge changes the grid layout; it does not append the contents of the selected cells.

How Google Sheets differs from Excel

In Google Sheets, the menu path is Format > Merge cells, and the Tool finder can locate the command. Excel has its own merge controls on the ribbon, so Sheets’ Tool finder shortcut should not be assumed to work there. The applications also differ in interface and available commands, even though both warn users about losing values outside the upper-left cell when merging a populated range. If a workbook will move between Sheets and Excel, test the layout in both applications and avoid merged cells in data-heavy tables where possible.

Frequently Asked Questions

What is the keyboard shortcut to merge cells in Google Sheets?
There is no dedicated direct shortcut for merging. Use Alt+/ on Windows or ChromeOS, or Option+/ on Mac, to open the Tool finder, search for merge cells, and choose a merge command.

Can I merge cells in Google Sheets without using the mouse?
Yes. Select the range using the keyboard, open the Tool finder with the relevant shortcut, search for the merge command, and choose it. The merge itself still requires selecting the desired command from the search results.

Does merging cells combine their text?
No. A merge changes the cell layout and keeps the upper-left cell’s value. Other contents in the range are removed, so copy or combine them separately before merging if you need to retain them.

How do I merge cells across each row?
Select the range and choose Format > Merge cells > Merge horizontally. This merges the cells across each row separately rather than turning the entire selection into one cell.

How do I undo a merge in Google Sheets?
Use Edit > Undo immediately after merging, or select the merged cell and choose Format > Merge cells > Unmerge. Unmerging restores the grid but does not restore values that were discarded.

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.