Merge Cells Horizontally in Google Sheets: Steps and Tips

To merge cells horizontally in Google Sheets, select the cells you want to combine, then choose Format > Merge cells > Merge horizontally. Sheets creates a separate horizontal merged cell for each row in your selection, keeping the leftmost cell’s content in each row and removing content from the other selected cells.

What horizontal merging does

Horizontal merging joins neighboring cells across columns while keeping rows separate. For example, select A1:C3 and choose Merge horizontally: Sheets merges A1:C1, A2:C2, and A3:C3. You get three wide cells, not one large cell spanning all three rows. This makes the option useful for row-by-row labels, section headings, or presentation layouts.

A merged cell occupies the space of several cells, but it is still anchored to the upper-left cell of the area it covers. In the example above, the resulting cells are anchored at A1, A2, and A3. This matters when you edit a value or refer to a cell in a formula: the visible merged area does not become a new independent range.

Merging is a layout change, not a way to combine text. If A1 contains a department name and B1 contains a manager, merging A1:B1 does not join those two pieces of text. The value in A1 remains, and B1’s content is discarded. If you need both values in one cell, use a text-combining method instead.

How to merge cells horizontally

Select a rectangular range of adjacent cells. To merge one row, select cells such as B2:D2. To merge several rows independently, select a range such as B2:D5.
Open Format in the Google Sheets menu bar.
Point to Merge cells, then choose Merge horizontally.
Check the result and the contents of each merged area. If the cells contained data, make sure the retained leftmost values are the ones you intended to keep.

You can also use the merge control in the toolbar when it is visible. Select the range, open the merge control’s dropdown, and choose Merge horizontally. The toolbar control may appear as an icon rather than a text label, so the Format menu is a dependable way to find the command. If the option is unavailable, check whether the selection is a valid rectangular range and whether it overlaps cells that are already merged.

For a single heading across several columns, select only the cells in that heading’s row. For a repeated layout with one heading area in each row, select the same number of columns across all the intended rows. Before applying the command to a large area, try it on a small example or make a copy of the sheet if the existing data is important.

What happens to existing data

Merging can remove data, so check the selected cells before you apply it. In each horizontal group, Google Sheets keeps the value from the leftmost cell and clears the values in the cells to its right. For example, if A2 contains Sales and B2 contains East, merging A2:B2 leaves Sales in the merged cell; East does not get added to it.

If a row has several values you need to retain, copy or combine them before merging. For a simple example, assume A1 contains North and B1 contains Region. To place both words in C1 with a space between them, enter =A1&" "&B1 in C1; the result is North Region. This formula combines text in the worksheet, whereas merging changes how cells are laid out. You can then copy the result and use Edit > Paste special > Values only if you want a fixed text value rather than a formula. Check the menu options available in your sheet before clearing or overwriting the source cells.

Cells that look empty can also contain formulas that return an empty string, spaces, or other details that are not immediately obvious. Review the formula bar when a cell is selected, and consider copying the range first if you are unsure. A merge warning may appear when the selection contains data, but do not treat a warning as a backup: decide in advance which values matter.

Choose the right merge option

The Merge cells menu offers different layouts. The right option depends on whether you want one large area or a series of row- or column-based areas:

Merge all combines the entire selected rectangular range into one cell. Select A1:C3, for example, and the result is one merged area covering those nine cells.
Merge horizontally combines cells across columns within each row. The same A1:C3 selection becomes three merged areas, one per row.
Merge vertically combines cells down rows within each column. A1:C3 becomes one merged area in each of the three columns.

These options are easy to confuse when selecting more than one row. If your aim is one title spanning the full width and height of a rectangular block, Merge all is the relevant layout. If you want a wide heading in every row, use Merge horizontally. If you want tall cells down the selected columns, use Merge vertically. Look at the selection outline and consider the intended shape before choosing.

For a single row, Merge horizontally and Merge all may produce the same visible shape. For a selection containing multiple rows, they do not: Merge all creates one cell, while Merge horizontally creates one merged cell per row. This distinction is especially important when applying a command to multiple rows of labels or records.

Formatting merged cells

After merging, you can format the resulting cell like other cells. Use the toolbar to adjust horizontal and vertical alignment, text wrapping, font, fill color, and borders. A common heading layout is to merge a short row of cells horizontally, center the text, apply a background color, and make the font bold. Alignment changes how the retained content appears; they do not change which value survived the merge.

Text may not fit simply because the merged area is too narrow or the content is long. Widen the columns involved, turn on text wrapping, or shorten the label. Merging more columns can create room visually, but it is not always the best fix: a wider merged area can make nearby data harder to scan and can complicate later sorting or filtering.

Borders and fill colors can also affect how the result looks. If the merged area has an unexpected border, select it and adjust the border controls. When applying formatting to many rows, verify a few rows at the top and bottom of the range; mixed formatting in the original cells may make the result less uniform than expected.

Sorting, filtering, and worksheet structure

Merged cells are usually best reserved for presentation areas, such as titles above a table. They can make data tables harder to sort and filter because a merged area does not behave like a separate value in every cell it covers. If a merged cell intersects a range you want to sort, Sheets may block the operation or the layout may not move as you expect. Unmerge cells in the data range before sorting, then sort the unmerged records.

The same caution applies to filter views, copying ranges, and extending a table. A clean data table generally has one header value in each column and one record per row, with no merged cells inside the table. Keep decorative headings above the table rather than merging cells in the header or body. This makes each column’s meaning explicit and gives Sheets a regular range to work with.

Merges can also make selecting and editing individual underlying cells less straightforward, since several grid positions act as one visible area. If you need to enter separate values later, unmerge the area first. A layout that looks polished on screen may be less convenient for collaborators who need to filter, paste, or analyze the data.

Alternatives when you need the text, not the layout

If your goal is to put multiple values together, combine the contents rather than merge the cells. With North in A1 and Region in B1, the formula =A1&" "&B1 returns North Region in the formula cell. You can use a comma, dash, or other separator by changing the text between the quotation marks. This preserves the original cells, which can still be used for sorting and calculations.

If the aim is only to make a heading appear centered over several columns, consider centering the text in one cell and leaving the neighboring cells unmerged. Place the heading in the leftmost cell, select the range, and use the horizontal alignment control to center it across the selection if that option is available in your current Sheets interface. Another simple approach is to center the heading in its own cell and adjust column widths. Avoid merging simply to make text look centered if the underlying range needs to remain easy to edit as a table.

For a document intended mainly for printing or presentation, merging may be a reasonable choice. For a working dataset, separate cells or a combined-text formula are usually more flexible. Choose based on what the sheet must do after it is formatted, not just how it looks at the moment.

Undoing or reversing a merge

To reverse a merge, select the merged cell or cells, then choose Format > Merge cells > Unmerge. The original grid positions return, but the values that were cleared during the merge do not automatically come back. Unmerging restores the cell structure, not the deleted contents.

If you have just merged cells and realize it was a mistake, use Edit > Undo or the undo button in the toolbar. Undo is most useful immediately after the action, before other edits make it harder to return to the earlier state. If the data is important, preserve a copy before merging rather than relying on undo as a recovery plan.

When only some rows in a selection need to be merged, unmerge the full affected range and then apply horizontal merging to the intended rows separately. This gives you more control than trying to repair a large mixed layout cell by cell.

Frequently Asked Questions

Can I merge cells horizontally across multiple rows?
Yes. Select a rectangular range spanning the rows and columns, then choose Format > Merge cells > Merge horizontally. Sheets creates one merged area per row, not one merged area for the whole selection.

Will merging cells combine their text?
No. A merge changes the layout. In each horizontal group, Sheets keeps the leftmost cell’s content and removes content from the other selected cells. Combine the values with a formula or copy them elsewhere first if you need to preserve them all.

How do I merge cells horizontally without losing data?
First combine or copy any values you need to keep, then merge. For two text values, a formula such as =A1&" "&B1 combines the contents of A1 and B1 with a space. Verify the result before removing or overwriting the original entries.

Why is Merge horizontally unavailable?
Check that you selected adjacent cells in a rectangular range and that the selection does not conflict with existing merged cells. If the range includes a merge already, unmerge the affected cells and try again. The Format menu can help you confirm which merge commands are available for the current selection.

How do I unmerge cells in Google Sheets?
Select the merged area and choose Format > Merge cells > Unmerge. This restores the separate cells, but it does not recover values that were cleared when the cells were originally 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.