Google Sheets Merge Cells Within a Table? What Works

How-to basics · Updated November 21, 2026

No. Google Sheets does not let you merge cells inside a Sheets table; to use merged cells, first convert the table to a regular range. Select a cell in the table, choose Format > Convert to range, then select the cells you want and use Format > Merge cells.

What Google Sheets Means by a Table

A Sheets table is more than a block of cells with borders or alternating colors. It is a structured range created with Google Sheets’ table feature, which can provide table-specific formatting and controls, such as column types and options for managing the table. To create one, select a data range and choose Format > Convert to table. The table has a header row and is intended to hold records arranged consistently across columns.

That structure is useful for lists such as orders, inventory, project tasks, or survey responses. Each row represents one record, and each column represents one kind of information. A table works best when every record follows the same layout—for example, Order ID, Date, Customer, and Status. A merged cell that spans two or more columns or rows cuts across that regular grid, which is why merging does not fit the table feature.

Can You Merge Cells Inside a Table?

No—not while the range is still a Google Sheets table. The merge command may be unavailable or may not work for a selection within the table. This is a restriction of the table structure, not a problem with your account or a sign that you selected the wrong cells.

There is an important distinction between a table and a normal range that looks like one. Applying borders, a fill color, or alternating colors to an ordinary range does not necessarily make it a Sheets table. If your cells are just a formatted range, you can select them and use the merge command. If they belong to a table created with Convert to table, convert that table back to a range first.

How to Convert a Table to a Range and Merge Cells

Use these steps in Google Sheets in a web browser:

  1. Click any cell inside the table. Confirm that the selection is within the table you want to change.
  2. Choose Format > Convert to range. If Sheets asks you to confirm, review the prompt and confirm the conversion.
  3. Select the cells you want to merge. Drag across the cells, or click the first cell and Shift-click the last cell in the desired block.
  4. Choose Format > Merge cells, then select the appropriate option. Merge all combines the selection into one cell; Merge horizontally combines cells across each selected row; Merge vertically combines cells down each selected column.
  5. Check the result and adjust alignment, wrapping, or column widths if needed.

For example, if a report has a title that should sit above columns A through D, convert the table to a range, select A1:D1, and choose Format > Merge cells > Merge all. Do not merge the header cells for four separate data columns: doing so removes the individual column labels and makes the data harder to sort or interpret.

What Changes When You Convert a Table

Convert to range removes the table’s special structure, but it is not the same as deleting the cells. The data remains in the sheet, and much of the visible formatting may remain. The table-specific controls and behaviors are no longer attached to that range, however, so check the result before relying on it. In particular, confirm that the header row, colors, filters, and any settings you depended on still work as you expect.

Conversion is not the same as clearing formatting or deleting data. Still, it changes how Sheets treats the range, and converting it back to a table later may require you to review the table setup. If the table is important, make a copy of the sheet first: right-click the sheet tab and choose Duplicate. That gives you a fallback if the converted layout is not what you wanted.

It is also worth considering whether you need to convert the whole table. If the only goal is a prominent title, you can place the title in a row above the table, outside its boundaries. That preserves the table structure and often avoids any conversion at all.

Why Merging Cells Can Cause Problems in Data

Merging is mainly a presentation tool. It can make a report title look neat, but it can make a data table less usable. Sorting and filtering work most reliably when each row has a value in each relevant column and the same column has the same meaning throughout. Merged cells interrupt that pattern: one label may appear to apply to several rows, while only one cell actually contains the value.

For instance, imagine a task list with columns for Team, Owner, Task, and Due date. Merging one Team cell vertically beside several tasks can look tidy, but it leaves the team value absent from the other task rows. A filter, a pivot table, or another analysis step may then treat those rows as blank for Team. Filling the team name into each row is usually a better data layout.

Merging can also discard cell contents. When several non-empty cells are merged, Sheets may warn that only the upper-left value will be kept. The other values are not combined into a sentence; they can be lost from the merged result. Before proceeding, copy any values you need, or join them into a single cell separately if that is what the layout requires.

Safer Ways to Make Headings Stand Out

If you want a heading to look centered over several columns, a merged cell is only one option. These alternatives often preserve a clean, usable table:

  • Put a title above the table. Use a row outside the table for the report title and leave the table’s headers unchanged.
  • Use text wrapping and alignment. Select the heading cell and use the toolbar’s horizontal alignment and text-wrapping controls. A taller header row can display longer labels without joining cells.
  • Widen the column. Drag the boundary between column letters to give a long heading more room, or shorten the wording while keeping its meaning clear.
  • Use formatting instead of merging. Bold text, a fill color, borders, or a larger font can distinguish a heading while leaving each column separate.
  • Use a group label in its own row. If you need a section label over a group of columns in a presentation-style report, place it above the data range rather than inside the table’s header or records.

These methods are especially useful when the sheet will be sorted, filtered, copied into another tool, or used as the source for a chart. They keep each column and record explicit, which makes the sheet easier for other people—and for spreadsheet features—to understand.

When Merging Cells Is Appropriate

Merging can still be reasonable in a layout designed primarily for reading or printing rather than analysis. Examples include a large title above a one-page summary, a decorative label in a cover sheet, or a form where the cells are not being used as a database-like list. In those cases, convert the table to a range if necessary, and merge only the cells that need to appear as one visual area.

Keep the underlying data separate wherever possible. A useful compromise is to maintain one sheet as a tidy table for filtering and analysis, and create a separate report sheet that uses merged cells for presentation. That way, the attractive layout does not interfere with the structured source data. If the report is based on values from the data sheet, make sure the report stays in sync when the source changes.

Google Sheets Tables Compared With Regular Ranges and Excel

In Google Sheets, a regular range can be formatted to look like a table without being a table created by Format > Convert to table. You can merge cells in a normal range through Format > Merge cells, subject to the usual selection and data-loss considerations. The visual appearance alone does not determine whether the table restriction applies; the range’s status does.

Microsoft Excel has a related distinction: an Excel Table is a structured data object, not just formatted cells, and merged cells are not supported within an Excel Table. Excel users commonly convert a table to a range before merging. The interface and exact commands differ between products, so follow the Google Sheets menu paths above rather than assuming an Excel command will be available in Sheets.

If you are sharing the file with someone who may open it in Excel, remember that converting a Sheets table to a range does not guarantee every Sheets-specific feature will behave identically in Excel. For a dependable handoff, keep the source data as a simple rectangular range with one header row, avoid merged cells in the data area, and check the exported or shared file in the destination application.

Common Problems and Troubleshooting

  • The merge command is disabled. Check whether the selected cells are inside a Sheets table. Convert to range, then select the cells again.
  • Only one value remains after merging. That is expected when selected cells contain multiple values. Undo immediately with Ctrl+Z on Windows or Chromebook, or Command+Z on Mac, then copy or combine the values before trying again.
  • The result is hard to read. Use the toolbar to change horizontal or vertical alignment, turn on text wrapping, or adjust row height and column width.
  • The table no longer has its table controls. Conversion removes table behavior by design. If you still need those controls, undo the conversion before making other edits, or recreate the table after revising the layout.
  • You are unsure whether the range is a table. Click inside it and inspect the table-specific controls and the Format menu. If converting the range is available, use it only if you are comfortable giving up the table structure.

Frequently Asked Questions

Can I merge cells in a Google Sheets table without converting it?
No. Convert the table to a range first, or place the heading outside the table so the table itself remains structured.

Where is Merge cells in Google Sheets?
Select the cells, then choose Format > Merge cells. The submenu offers options such as Merge all, Merge horizontally, and Merge vertically. The command does not make an in-table merge possible while the selection belongs to a Sheets table.

Will converting a table to a range delete my data?
Converting is intended to remove the table structure, not erase its cell contents. Review the range afterward because table-specific controls and behaviors are removed, and check that the formatting you need remains.

Does merging cells combine their text?
No. If multiple selected cells contain data, Sheets keeps the upper-left value in the merged result and may warn you before continuing. Copy or combine any other values first.

Can I turn the range back into a table later?
You can select the range and use Format > Convert to table, then review the table setup. Do not assume that every earlier table setting will be restored automatically.

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.