Google Sheets Merge Cells Shortcut and Options

How-to basics · Updated November 21, 2026

Google Sheets has no dedicated one-step keyboard shortcut for merging cells. In a browser, press Alt+/ on Windows or ChromeOS, or Option+/ on Mac, search for “Merge cells,” then choose the merge command you need; you can also use Format > Merge cells.

Is there a direct merge-cells shortcut?

There is no standard Google Sheets key combination that directly merges the selected cells in one step, such as a shortcut that works simply by pressing Ctrl and another key. The useful keyboard route is the menu search, also called the tool finder. It lets you find and run Sheets commands without opening each menu by hand.

That distinction matters: Alt+/ or Option+/ opens search; it does not merge cells by itself. You still need to type a command and select the appropriate result. The merge choices depend on the shape of your selection, so check whether you want to merge everything into one cell, merge across rows, or merge down columns.

The shortcut applies to Google Sheets in a web browser. It is not an Excel shortcut, and it may behave differently in a browser or operating system that intercepts the same key combination. If it does not open menu search, use the Format menu instead.

How to merge cells with menu search

Use this approach when you want to keep your hands on the keyboard or cannot immediately find the merge control in the menus:

  1. Select the adjacent cells you want to combine. You can drag across them or select a range using the name box.
  2. Press Alt+/ on Windows or ChromeOS, or Option+/ on Mac.
  3. Type Merge cells into the search field.
  4. Choose the result that matches your intention, such as Merge all, Merge horizontally, or Merge vertically.
  5. Read any warning about existing contents before confirming the action.

For example, if you select A1:C1 for a report heading, choose Merge all to create one wider cell. If you select A1:C3 and want each row joined across its columns, choose Merge horizontally; that produces one merged cell per row rather than one large merged block.

Using the Format menu instead

The menu route is straightforward and works even if the keyboard combination is unavailable: select the range, then choose Format > Merge cells. The submenu presents the available merge actions. Depending on the selection, some choices may be unavailable or may not make sense for that range.

Menu search is useful when you do not remember the menu location, while the Format menu makes the choices visible before you click. Both routes invoke the same Sheets commands; the search shortcut does not enable a different kind of merge or change what happens to the cell contents.

Google Sheets may also show a merge control in the toolbar, depending on the toolbar layout and available space. It is a convenient mouse option, but the menu path is easier to describe consistently because the toolbar can be condensed on smaller windows.

What the different merge options do

Sheets offers more than one way to merge, and the range’s layout determines which option is appropriate:

  • Merge all combines the entire selected rectangular range into one cell. Selecting A1:C3 and using this option creates one cell spanning all three columns and all three rows.
  • Merge horizontally joins cells across each selected row. For A1:C3, the result is three merged cells: A1:C1, A2:C2, and A3:C3.
  • Merge vertically joins cells down each selected column. For A1:C3, the result is three merged cells: A1:A3, B1:B3, and C1:C3.
  • Unmerge removes the merged arrangement and restores the individual cell grid in the selected area.

These actions are not interchangeable. A heading spanning several columns usually calls for Merge all on a single row. A label that should cover multiple entries in one column may call for Merge vertically. If you are unsure, consider whether you need one large cell or a series of merged cells before choosing.

What happens to data when cells are merged?

Merging is a layout operation, not a way to combine the values from several cells into a longer value. When the selected cells contain multiple entries, Sheets keeps the value in the top-left cell and discards the contents of the other cells in the merge. For example, merging A1:C1 when A1 contains “Quarter” and B1 contains “Sales” does not produce “Quarter Sales”; the top-left value is kept and the other entry is removed.

That is why Sheets may show a warning before completing a merge that would discard data. Treat that warning seriously, particularly in a shared or important spreadsheet. If every entry matters, cancel the merge and move or combine the data first. For text that needs to be joined, use a formula or edit a separate cell rather than relying on merging.

Formatting and contents are separate concerns. A merged cell can display its remaining value across a larger area, but it still behaves as one cell for many spreadsheet operations. It does not turn the range into multiple independently editable cells or create a new data structure.

When merging is useful—and when it is not

Merging is most useful for presentation. A common example is a report title placed above several columns: merging A1:D1 can make the heading appear centered over the table. It can also help create a simple form label that visually spans a group of rows or columns.

For tables that people sort, filter, update, or analyze, merged cells are often more trouble than they are worth. A merged heading inside the data area can make the grid uneven, and merged ranges may interfere with selecting, sorting, filtering, pasting, or inserting cells. Keep the main data table in a regular rectangular layout, with one value per cell and one consistent header row.

A useful rule is to merge for a decorative heading outside the data range, not to represent a relationship between records. If a category applies to several rows, repeating the category in each row is usually easier to sort and filter than merging its cells vertically.

Common shortcut and merge problems

  • Alt+/ does nothing: Confirm that the spreadsheet is active and that the browser or operating system has not captured the key combination. Try the Format menu, or use the equivalent Mac key, Option+/.
  • The desired merge choice is unavailable: Check that you selected a suitable adjacent rectangular range. A single cell cannot be meaningfully merged with itself, and existing merged areas can complicate a new selection.
  • Some values disappear: This is expected if multiple selected cells contain data. Sheets retains the top-left value when merging; cancel if you need to preserve the other entries.
  • The merged heading looks off-center: Merging and alignment are separate. Select the merged cell and use the horizontal alignment control on the toolbar to choose the alignment you want.
  • Sorting or filtering becomes awkward: Unmerge cells within the data range and make the table rectangular. Keep visual headings outside the range you intend to sort or filter.

Alternatives to merging

If the goal is simply to make a heading look prominent, try formatting without merging. You can select the heading cell, adjust horizontal alignment, apply bold text or a fill color, and resize columns or rows. These changes preserve the underlying grid, so nearby cells remain independent.

For a heading centered over a group of columns, one practical alternative is to place it in a single cell and adjust its alignment and column widths to suit the layout. This may not look exactly like a merged heading in every sheet, but it avoids creating a merged range that can complicate later edits. Google Sheets does not provide Excel’s distinct “Center Across Selection” alignment option, so do not look for that Excel command in Sheets.

If the goal is to show a combined label, keep the source values intact and create the combined text in a separate cell or column. That preserves the original data for filtering and reuse. Choose merging only when the visual layout is more important than treating each cell in the selected range as separate data.

How to undo or reverse a merge

If you have just merged cells and the result is wrong, use Ctrl+Z on Windows or ChromeOS, or Command+Z on Mac, to undo the action. This is the best immediate response if the merge removed contents you wanted to keep. In a shared spreadsheet, undo may also affect the sheet’s recent edit history, so check the result before continuing.

To reverse a merge later, select the merged cell or range and choose Format > Merge cells > Unmerge, or search for the unmerge command using menu search. Unmerging restores separate cells, but it does not restore values that were discarded during the original merge. Recover those from undo, version history, or another copy if they are no longer present.

Frequently Asked Questions

What is the shortcut to merge cells in Google Sheets?
There is no dedicated direct merge shortcut. Use Alt+/ on Windows or ChromeOS, or Option+/ on Mac, then search for “Merge cells” and choose the desired command.

Can I merge cells in Google Sheets without a mouse?
Yes. Select the range with the keyboard, open menu search with Alt+/ or Option+/, search for the merge command, and select the appropriate result. The exact range-selection keys can depend on your keyboard and browser.

Does merging cells combine their text?
No. Merging does not concatenate text. Sheets keeps the top-left cell’s value and discards other contents in the merged range, so combine or move values first if they all need to be retained.

How do I unmerge cells in Google Sheets?
Select the merged area and choose Format > Merge cells > Unmerge. You can also find the unmerge command through menu search. Unmerging restores the cell grid but does not recover values already discarded.

Is the Google Sheets shortcut the same in Excel?
No. The instructions here are for Google Sheets in a browser. Excel has its own merge commands and keyboard behavior, which vary by platform and version; Google Sheets menu search is not an Excel shortcut.

Related

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.