Merge Cells in Google Sheets: Shortcut and Steps Explained

Google Sheets does not provide a dedicated default keyboard shortcut that merges selected cells in one keystroke. In a browser, the quickest keyboard-based route is to press Alt+/ on Windows or Option+/ on Mac, search for the merge command, and choose it; you can also use Format > Merge cells and select the merge type.

Is there a dedicated merge-cells shortcut?

There is no standard, single-key combination assigned specifically to merge cells in Google Sheets. That is why shortcut lists you may find online can be confusing: some describe menu navigation, browser-specific behavior, or a shortcut in a different spreadsheet program rather than a built-in Google Sheets merge command.

Google Sheets does have a menu-search shortcut. On many Windows and ChromeOS keyboards, Alt+/ opens Search the menus; on a Mac, use Option+/. Type a phrase such as Merge cells and select the relevant command from the results. This is a way to reach a menu command quickly, not a dedicated merge shortcut: it still involves searching for and choosing an action. If the key combination is intercepted by your browser, operating system, or keyboard layout, use the menus instead.

The fastest reliable way to merge cells

For a predictable result, select the cells first and use the Format menu. These steps apply to Google Sheets in a web browser:

Click and drag across the cells you want to combine, or select a range using the keyboard. Check that the highlighted range is exactly the one you intend to merge.
Open Format > Merge cells.
Choose Merge all, Merge vertically, or Merge horizontally, as appropriate. If the selection cannot be merged in that direction, the corresponding option may be unavailable.

You can also try the menu-search route: press Alt+/ on Windows or Option+/ on Mac, type Merge cells, and select the desired command in the results. Search results can include more than one merge action, so read the command name rather than automatically choosing the first result. If you do not see a suitable result, the Format menu exposes the available choices directly.

The toolbar may also show a merge-cells control when a range is selected. Its dropdown provides merge choices in many Sheets layouts. The toolbar is convenient when you use merging often, but the Format menu is clearer when you need to confirm whether you want a full merge, a horizontal merge, or a vertical one.

What the three merge options do

The merge choices determine how Sheets combines a rectangular selection. For example, if you select A1:C2, each option produces a different layout:

Merge all: Combines the entire selected rectangle into one cell. A1:C2 becomes one large cell.
Merge horizontally: Combines cells across each selected row. In the example, A1:C1 becomes one cell and A2:C2 becomes another.
Merge vertically: Combines cells down each selected column. In the example, A1:A2, B1:B2, and C1:C2 become three separate cells.

These distinctions matter in tables. If you want a single heading spanning three columns above a table, select the heading row’s three cells and use Merge horizontally (or Merge all, since that selection is only one row). If you select several rows and want a single cell for the whole area, Merge all is the appropriate choice. Do not assume that Merge cells always means the same operation: the range’s shape and the selected option determine the result.

What happens to the contents of selected cells?

Merging changes the cell structure; it does not combine the values into a sentence or preserve every value as separate content. When the selected cells contain multiple entries, Google Sheets keeps the content in the upper-left cell and removes the contents of the other cells in the merged range. For instance, if A1 contains Quarter, B1 contains Revenue, and you merge A1:B1, Quarter remains and the content of B1 is discarded.

Before merging, inspect the selected cells and copy any values you need to keep. If your goal is to display several text entries together, combine or move the text into one cell first rather than relying on merge to concatenate it. Merging is a layout operation, not a data-joining operation. Likewise, it does not average, add, or otherwise summarize numbers in the cells being merged.

Pay attention to formulas as well as visible text. A formula in a non-upper-left cell can be lost when its cell is merged into the range. If you are uncertain, duplicate the relevant data to another range or make a copy of the sheet before changing a large or important layout.

When merging is useful

Merged cells can make a title or section heading visually span several columns. A monthly report, for example, might have a title above columns for date, department, and amount. A merged heading can make the report easier to scan when it is printed or shared as a presentation-style summary.

It is most suitable for labels and presentation areas that are not part of the sheet’s row-by-row data structure. Common uses include:

A report title centered over a group of columns.
A section label above a block of figures.
A form heading that spans related fields.
A visual grouping in a small dashboard or printable summary.

For a title spanning columns A through D, select the relevant cells in the title row and merge them horizontally. Enter the title in the upper-left cell before or after merging, then use the alignment controls if you want it centered. Merging itself does not necessarily center text; alignment is a separate formatting choice.

When merging can cause problems

Merging cells inside a conventional data table can make the sheet harder to sort, filter, fill, or analyze. Many spreadsheet operations work best when each row is one record and each column is one field, with a single header row. A merged cell crossing several records breaks that regular grid: some cells in the affected rows no longer have the same structure as the rest of the table.

For example, avoid merging a department name vertically across ten employee rows if you may later sort those employees by salary or filter the table by department. Instead, repeat the department name on each row, or use formatting such as borders, color, or indentation to show a visual group. Repeated values are often more useful for sorting, filtering, and importing data into other tools.

Merged cells can also complicate selecting ranges and pasting data. A pasted block may not match the merged layout, and a sort may be unavailable or behave differently when the selected area contains merged cells. If a command is disabled or a paste gives an unexpected result, look for merged cells within the relevant range. Unmerging and restoring a regular grid is often the simplest fix.

How to undo or unmerge cells

If you merged the wrong range just now, use Edit > Undo or the browser’s undo control. The familiar keyboard command is Ctrl+Z on Windows and Chromebook, or Command+Z on Mac. Undo is useful immediately after an accidental merge, but it is not a substitute for checking what happened to values in the other cells.

To reverse a merge later, select the merged cell or range and choose Format > Merge cells > Unmerge. Unmerging restores separate cells, but it does not automatically recreate content that was removed from cells during the original merge. If a value was overwritten or discarded, use version history or a backup if available; unmerge alone cannot bring it back.

After unmerging, the existing value remains in one cell and the other cells are typically blank. You may need to re-enter labels, copy formulas, or adjust borders and alignment to restore the original table. Review the affected rows and columns before continuing with a sort, filter, or paste.

Keyboard and browser differences

Google Sheets is a web app, so the menu-search keys can be affected by the browser, operating system, and keyboard layout. Alt+/ is commonly used on Windows and Chromebook, while Option+/ is the corresponding Mac menu-search shortcut in Google Sheets. On some keyboard layouts, producing the slash character requires an additional key; if the shortcut does not open menu search, click Format instead.

Google Sheets also has a separate keyboard-shortcut reference that you can open from Help > Keyboard shortcuts. That reference is useful for checking the shortcuts available in the current app. It does not mean every menu action has a dedicated shortcut. In particular, do not assume a sequence published for Excel will work in Google Sheets: the applications have different menus and shortcut conventions. Excel’s merge commands and ribbon-key sequences are not a substitute for the Google Sheets menu path.

Alternatives to merging cells

If you want a heading to look centered across columns but need to keep every cell independent, use Center across selection only if you are working in software that offers that feature; it is not the Google Sheets merge command. In Sheets, you can instead place the heading in one cell, adjust column widths, and use alignment and text wrapping to make it readable. Another option is to put the heading in a separate row above the data and leave the underlying table unmerged.

For grouped data, repeat labels rather than merging them. You can apply background colors, borders, bold text, or indentation to make groups clear without changing the rectangular structure. This is particularly helpful when the sheet will be filtered, sorted, copied, or used as a data source for a chart or another application.

Choose merging when the primary purpose is visual layout and you understand that only the upper-left cell’s content is retained. Choose a regular, unmerged grid when preserving each value and keeping the data easy to work with matters more.

Frequently Asked Questions

What is the shortcut key to merge cells in Google Sheets?
There is no dedicated default one-keystroke merge shortcut. Use Alt+/ on Windows or Option+/ on Mac to search menus for Merge cells, or go to Format > Merge cells and choose an option.

Does Ctrl+M merge cells in Google Sheets?
No. Ctrl+M is not the standard Google Sheets merge-cells command on Windows. Use the Format menu or menu search instead. Shortcuts can differ between spreadsheet programs, so an Excel shortcut may not apply in Sheets.

How do I merge cells without losing data?
First move or copy any content you need to preserve into the upper-left cell or another location. A merge does not combine the values; content in other selected cells may be removed. Check the whole range before choosing a merge option.

How do I merge cells horizontally?
Select the cells across the row or rows, then choose Format > Merge cells > Merge horizontally. Each selected row is merged across its columns separately, rather than combining the entire selection into one cell.

How do I unmerge cells in Google Sheets?
Select the merged cell or range and choose Format > Merge cells > Unmerge. This restores separate cells, but it does not recover values that were discarded when the cells were first merged.

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.