How to Merge Cells in Google Sheets: Steps and Tips

To merge cells in Google Sheets, select the cells, then choose Format > Merge cells and pick a merge option. Merging combines a selected area into a larger cell, often useful for a heading that spans several columns. Before you confirm, check the selected cells: when a merge combines cells with content, Google Sheets keeps only the value in the upper-left cell of the merged area and removes the other values. The steps below are for Google Sheets in a desktop web browser.

What You’ll Need

A Google account with access to the spreadsheet, and a web browser with the sheet open.
A clear idea of which cells should become one cell. Check whether the other selected cells contain text, numbers, or formulas you need to keep.
Optional: a copy of the sheet or a saved version if you are changing an important layout. Merging can remove values from cells other than the top-left cell.

Step-by-Step

Open the spreadsheet and locate the range. Click the tab at the bottom that contains the cells you want to combine. Identify the first and last cell in the range. For example, if a heading should span columns A through D in row 1, the range is A1:D1. You can see the selected cell address in the name box to the left of the formula bar.
Check what is in each cell. Click the cells one at a time, or inspect the formula bar, to see whether cells besides the upper-left one contain anything. For a range such as A1:D1, A1 is the upper-left cell. If it contains the heading, but B1, C1, or D1 contains information, copy that information elsewhere before merging. A merge is a layout change, not a way to combine the contents of several cells into one sentence.
Select the cells to merge. Click the first cell, then drag across the range to the last cell. To select a rectangular range precisely, click the first cell, hold Shift, and click the last cell. You can also click the name box, type a range such as A1:D1, and press Enter. Confirm that the highlighted range includes exactly the cells you intend to merge; selecting an extra row or column can create an unexpected layout.
Open the merge options. In the menu bar, choose Format > Merge cells. You can also use the merge-cells button on the toolbar, if it is visible, and open its dropdown to see the available choices. The menu options are Merge all, Merge horizontally, and Merge vertically. If you do not see a merge option, check that you have selected more than one cell and that the sheet is not protected in a way that prevents editing.
Choose the option that matches your selection. Use Merge all to turn the whole selected rectangular range into one cell. Use Merge horizontally to merge cells across each row separately. For example, selecting A1:D3 and choosing this option creates one merged cell for A1:D1, one for A2:D2, and one for A3:D3. Use Merge vertically to merge cells down each column separately; with A1:C3 selected, it creates a merged cell in each of columns A, B, and C. For a single heading across a row, select only that row’s cells and choose Merge all or Merge horizontally.
Review any warning and confirm. If selected cells contain multiple values, Sheets may warn that merging keeps only the upper-left value. Stop if you need the other contents: choose the option to cancel, copy or move those values to other cells, then select the range again. If the upper-left value is the one you want to retain, proceed with the merge.
Check the result and adjust the presentation. Make sure the text is visible and the merged area is the intended size. Use the toolbar’s horizontal and vertical alignment controls to position the contents; for a heading, center alignment is often suitable. If the text is long, turn on text wrapping from the toolbar or use Format > Wrapping > Wrap. You may need to adjust row height, column width, borders, or fill color so the merged cell fits the rest of the sheet.
Undo or unmerge if the result is wrong. Immediately after merging, use Edit > Undo or Ctrl+Z on Windows and ChromeOS, or Command+Z on Mac, to reverse the change. To separate a merged cell later, select it and choose Format > Merge cells > Unmerge, or use the toolbar’s merge dropdown and choose Unmerge. Unmerging restores the individual cells as a layout, but it does not bring back values discarded when they were merged.

Common Mistakes

Merging before checking for extra values: This is the most important mistake to avoid. A merge does not concatenate text, add numbers, or preserve every cell’s content. Only the value in the upper-left cell of the merged area remains. For horizontal merges, that means the leftmost cell in each row; for vertical merges, it means the top cell in each column. Copy any needed information to an unmerged location before proceeding.

Choosing the wrong merge direction: Merge all makes one cell from the entire selected rectangle. Merge horizontally and Merge vertically create multiple merged cells if the selection covers multiple rows or columns. If you select a large block without considering the direction, you may end up with a different set of merged areas than expected. Start with a small example or select only the intended row or column.

Using merges in the middle of a data table: Merged cells can interfere with sorting, filtering, filling formulas, selecting ranges, and copying data. They are usually better for titles or section labels outside the table than for the rows and columns that hold sortable records. Keep a regular one-value-per-cell structure for data you plan to analyze.

Expecting unmerge to restore deleted contents: Unmerge separates the area visually, but it cannot reconstruct the values that the merge removed. Undo works only while the merge is still an undoable recent action. If you have continued editing or closed the file, check version history or a backup rather than assuming unmerge will recover the old entries.

Tips

Use a merged cell mainly for labels and headings. A title above a report is a good candidate because it is presentation text, not part of the underlying records. Keep column headers and individual data entries in separate cells where possible.
Make the upper-left cell the intended label. Put the heading in the leftmost cell of a horizontal range or the top cell of a vertical range before merging. This makes it clear which content Sheets will retain.
Save a safety copy before large layout changes. To create one, use File > Make a copy. For a small change, copying the values elsewhere on the same sheet may be enough, but keep the copies outside the range you plan to merge.
Use alignment and wrapping to improve readability. Merging does not automatically center text or make it fit. Set alignment separately, and use wrapping or resize the row and columns if text is clipped.
Consider a non-merge layout when the cells contain data. A heading can sometimes be placed in one cell with a suitable column width, or formatted with borders and fill color to make a section stand out. Google Sheets does not have Excel’s exact “Center Across Selection” command; in Excel, merge controls are on the Home tab, while the instructions here use the Google Sheets Format menu.

Troubleshooting

The merge option is unavailable or disabled. Select at least two adjacent cells in the same sheet and check that the selection is a valid rectangle. If you can view but not edit the cells, ask the owner to grant editing access or review Data > Protect sheets and ranges for restrictions. A filtered or protected range can also make editing difficult; remove or adjust the restriction only if you have permission.

The wrong cells were merged. If the change just happened, use Undo straight away. Otherwise, select the merged area and choose Format > Merge cells > Unmerge, then select the intended range and merge it again. Check the cell coordinates in the name box before you repeat the operation.

Text or numbers disappeared. The merge may have discarded contents outside the upper-left cell. First try Edit > Undo if the operation is still available. If it is not, open File > Version history > See version history and look for a version from before the merge. You can review or restore an earlier version, but consider making a copy first if you need to preserve current edits. Version history may not be available in the same way for every account or file.

The heading is cut off or looks off-center. Select the merged cell, check the horizontal and vertical alignment buttons on the toolbar, and choose the alignment you want. For clipped text, use Format > Wrapping > Wrap, then increase the row height or column width if necessary. Also check whether the font size or text rotation makes the label difficult to read.

Sorting or filtering behaves strangely afterward. If merged cells are inside the data range, unmerge them and restore a consistent grid with a separate value in each row and column. Keep decorative merged headings above or outside the range used for sorting and filtering. If you need a prominent label within a table, use formatting or a separate heading row rather than merging record cells.

Frequently Asked Questions

Can I merge cells without losing the contents of the other cells?
Not as part of a normal merge. Sheets retains the upper-left value and removes other contents in the merged range. Copy or combine the information in a separate cell before merging if you need to keep it.

What is the difference between Merge all and Merge horizontally?
Merge all turns the whole selected rectangle into one cell. Merge horizontally creates a separate merged cell for each row in the selected range. For a one-row selection, the visible result may look the same, but the options differ when multiple rows are selected.

Can I merge cells vertically?
Yes. Select cells in one or more columns and choose Format > Merge cells > Merge vertically. Each selected column is merged down the selected rows, and the top cell in each column supplies the retained value.

How do I undo a merge?
Use Edit > Undo immediately after merging, or select the merged cell and choose Format > Merge cells > Unmerge. Undo reverses the recent action; unmerge only separates the cell and does not recover content that was removed.

Can I merge cells in Google Sheets on a phone?
Google Sheets mobile apps have their own selection and formatting controls, and the menu layout can vary by device and app version. These exact menu steps are for a desktop browser. On mobile, select the range, open the formatting controls, and look for the cell merge option; check the selected range and contents before applying it.

Will merged cells work well in a spreadsheet I need to sort?
Usually not if the merged cells are part of the sortable data range. Merges can make rows uneven and interfere with sorting and filtering. Keep the data grid unmerged and use merged cells for a title or section heading outside that grid.

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.