LibreOffice Calc Merge Cells: Steps and Common Issues

To merge cells in LibreOffice Calc, select the adjacent cells, then choose Format > Merge and Unmerge Cells > Merge Cells or Merge and Center Cells. The second option also centers the content; before confirming a merge, check what will happen to any content outside the top-left cell.

What merging cells does

Merging combines a rectangular selection of neighboring cells into one larger cell on the sheet. For example, you could merge A1:D1 to make a heading span four columns, or merge A2:A4 to make one cell cover three rows. The surrounding worksheet grid still exists, but the merged area behaves as a single cell for editing and layout. Its top-left position is the cell that holds the merged cell’s content.

Merging is mainly a presentation feature. It does not combine a set of values into a meaningful calculation, and it does not turn several records into one well-structured data field. The cells that were covered by the merge are no longer independently editable while the merge remains in place. That distinction matters if you later want to sort, filter, copy, or calculate with the individual cells.

Calc offers a merge command that centers content as part of the operation and a merge command without that centering. The precise menu wording or toolbar layout can vary slightly by LibreOffice version, but the merge options are grouped under Format.

How to merge cells in Calc

Select a rectangular block of adjacent cells by dragging across the grid or selecting the first cell and extending the selection. For a heading across columns A through D in row 1, select A1:D1.
Choose Format > Merge and Unmerge Cells.
Choose Merge Cells to merge without adding center alignment, or choose Merge and Center Cells to merge and center the content.
If Calc warns that selected cells contain content, read the prompt and choose whether to move the hidden cells’ contents into the first cell. If the information matters, make a copy of it first and inspect the merged result.

You can also use the matching merge control on the toolbar when it is visible. If you do not see it, use the Format menu rather than assuming the feature is unavailable. To merge a heading across a row, select the full horizontal range; to create a vertically tall cell, select a range in one column. The selection needs to be rectangular, and merging does not create several separate merged cells from a scattered selection.

Merge Cells versus Merge and Center Cells

Merge Cells combines the selection but does not make centering part of the command. The merged cell keeps its applicable alignment settings, so its text might remain left-aligned or use another existing alignment. This option is useful when you want a wide cell but need to control alignment separately, or when preserving the current alignment is important.

Merge and Center Cells combines the cells and centers the content horizontally. It is convenient for a title such as Quarterly results spanning several columns. Centering does not automatically make the text vertically centered in every layout, nor does it guarantee that long text will fit: column widths, row height, wrapping, and other formatting still affect what appears on screen.

These commands are not the same as simply centering text in an ordinary cell. A merged range changes the worksheet structure for editing, while alignment changes how content appears inside a cell. If you only need a label to look centered, consider whether changing alignment or adjusting the layout can achieve the result without merging.

What happens to existing content

Before merging, identify which selected cells contain data, formulas, or labels. Calc may display a confirmation prompt when more than one selected cell contains content, asking whether the contents of hidden cells should be moved into the first cell. Read that prompt carefully: the top-left cell is the destination associated with the merged range, and choosing to discard other contents can remove information you intended to keep.

For example, suppose A1 contains Sales, B1 contains Costs, and C1 contains Profit. Merging A1:C1 is not a safe way to preserve those three column headings as separate fields. A merge makes one larger cell, not a row of combined labels. Keep the data in separate cells, or copy the labels to a safe location before changing the layout. If the merge prompt offers to move content, verify how the resulting cell reads rather than assuming that every value will remain separately accessible.

Formulas in cells within the selected area deserve the same care as typed values. A formula may be moved or lost depending on the merge choice, and the merged area no longer offers each original position as an independent formula cell. Save a copy or use Undo immediately if the outcome is not what you expected. Undo can reverse a recent merge, but it is not a substitute for a backup when you have made other changes afterward.

When merging is useful—and when it is not

Merging can make a report or printed sheet easier to scan when a label genuinely needs to span columns or rows. Typical examples include a report title above a small, fixed table, a section heading across a group of columns, or a form label arranged across a designed area. It can also help align a heading visually with the content beneath it.

Use merged cells sparingly in the body of a data table. A table works best when each row represents one record and each column represents one field. If a heading is merged across columns or cells are merged inside the records, sorting, filtering, filling formulas, selecting a consistent range, and exporting the data may become more awkward. A visually polished sheet is not necessarily a well-structured dataset.

A practical rule is to reserve merges for presentation areas outside the table’s data records. Keep column headers and individual values in separate cells when you expect to analyze or reuse the data. For example, a merged title above a sales table is usually less disruptive than merging cells within the rows containing dates, products, and amounts.

Formatting and layout after a merge

After merging, check the result at the worksheet zoom level and in print preview if the sheet will be printed. A long heading may need a wider range, a taller row, or text wrapping. Adjusting row height and column widths can improve readability, but remember that changing a column width affects other cells in that column too.

Alignment and borders are separate from the act of merging. You can set text alignment, apply a background color, or add borders using the normal cell-formatting controls. Check the outside edges of the merged region in particular: a border applied before the merge may not look the way you expect afterward. If a merged cell’s appearance is inconsistent with neighboring cells, adjust its formatting after the merge and inspect the surrounding grid.

For a heading that should be centered but not merged, keep the text in one cell and use the alignment controls, or design the heading in a separate area above the table. This avoids turning several cells into one. It is especially useful when the worksheet may later be sorted or expanded, because the underlying data columns remain separate.

Unmerge cells and recover the layout

To reverse a merge, select the merged cell and choose Format > Merge and Unmerge Cells > Unmerge Cells. The original cell boundaries return. The content remains associated with the top-left cell; the other cells in the former range are generally empty, rather than being restored as the separate values they once held. Unmerging restores the grid structure, not necessarily every earlier value or formatting choice.

If you merged cells moments ago and want to restore the original content as well, use Ctrl+Z on Windows or Command+Z on macOS while the merge is still the most recent action. If other edits have followed, undoing repeatedly could reverse those too, so review the changes as you go. For a workbook that contains important information, save a separate copy before trying a large set of merges.

Common problems and practical fixes

The merge command is unavailable or does not work: Confirm that you selected a rectangular group of adjacent cells and that the sheet is not protected against the change. If a cell is in an unusual selection state, click an ordinary worksheet range and select it again.
Some information disappeared: Undo immediately if possible. Otherwise, check the confirmation choice and any backup or earlier saved version. Unmerging alone will not recreate values that were removed during the merge.
Sorting or filtering behaves unexpectedly: Look for merged cells within the range being sorted or filtered. For data work, unmerge those cells and put each header or record value into its own cell; use formatting for visual grouping instead.
The text looks clipped: Increase the column width or row height, or use text wrapping and inspect the result. Merging does not automatically resize the surrounding worksheet to fit every label.
Copying the range produces an awkward result: Merged cells can make source and destination shapes difficult to match. Copy a range with the same layout, or unmerge the source first if each underlying cell needs to be copied independently.

When a sheet is shared with other people or used as input to another program, consistent unmerged data is usually easier to maintain. A merge that looks harmless in a small report can become a source of confusion when the range grows or someone needs to process its values.

Frequently Asked Questions

How do I merge cells in LibreOffice Calc without centering?
Select the rectangular range, then choose Format > Merge and Unmerge Cells > Merge Cells. Use Merge and Center Cells only when you also want the content centered.

Can I merge cells that contain different text?
Calc may ask whether to move the contents of hidden cells into the first cell. Read the prompt and verify the result; do not treat merging as a reliable way to combine separate labels or records. Copy important content elsewhere first.

How do I unmerge cells in Calc?
Select the merged cell and choose Format > Merge and Unmerge Cells > Unmerge Cells. The cell grid returns, but the former contents are not necessarily restored to their original positions.

Why should I avoid merged cells in a data table?
Merged cells can interfere with operations that expect a regular row-and-column structure, including sorting, filtering, copying, and extending a table. Keep fields in individual cells when you need to analyze or reuse the data.

Does merging cells combine their values into one?
Not as a dependable data-concatenation operation. Merging creates one larger cell and may prompt you about the other contents, but it does not create a structured combination of separate values. Preserve and combine data deliberately before changing the layout.

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.