LibreOffice: How to Merge Table Cells in Writer and Calc

Yes. In LibreOffice Writer, select adjacent cells in a table and choose Table > Merge Cells; in Calc, select a rectangular range and use Format > Merge and Unmerge Cells. The steps are similar, but the apps handle existing cell contents differently, so check what you want to keep before merging.

Which LibreOffice app are you using?

LibreOffice includes more than one kind of table. Writer is the word processor, where a table sits within a document and its cells can contain paragraphs, text formatting, images, or other document content. Calc is the spreadsheet, where cells belong to a grid of rows and columns and may contain text, numbers, or formulas. Both applications let you merge cells, but the result and the risk to existing data are not the same.

If you are preparing a report, form, or document layout, you probably want to merge cells in Writer. If you are arranging a spreadsheet heading across several columns, you probably mean Calc. The instructions below cover both, and the section on preserving content is especially important for Calc.

Merge cells in a Writer table

Writer can combine neighboring cells that share an edge. The cells must be part of the same table, and you need to select the cells you intend to combine before using the command.

Click in the table, then select two or more adjacent cells. Drag across the cells with the mouse, taking care not to select text alone.
Choose Table > Merge Cells from the menu. If you prefer, right-click the selected cells and choose Merge Cells from the context menu.
Review the result. The selected cells become one larger cell; adjust its text, paragraph spacing, borders, or alignment if needed.

The command may be unavailable when only one cell is selected or when the selection is not a valid group of neighboring cells. A rectangular group is the simplest selection to merge. For example, selecting the two cells at the top of a table can create one wider heading cell, while selecting two cells stacked in a column creates one taller cell.

What happens to Writer cell contents?

Writer is designed for document content, so merging cells is not simply a spreadsheet operation. Text from the selected cells is brought into the resulting cell. If several cells contain text, it may appear as separate paragraphs or retain paragraph formatting from the original cells. Check the merged result rather than assuming the text will become one continuous sentence.

For example, suppose a two-column table has the words “Department” and “Contact” in neighboring heading cells. Merging them does not automatically create the heading “Department Contact” in the exact style you might want. You may need to add a space, punctuation, or a line break, and adjust paragraph alignment. If the source cells had different direct formatting, you may also need to tidy the result.

Merging changes the table structure, not just the appearance of borders. If your only goal is to make cells look like one area, you could instead leave the cells separate and remove the internal border between them. That keeps the underlying cell divisions available for later editing.

Merge cells in LibreOffice Calc

In Calc, first select the rectangular range you want to combine. You can drag across the cells, or click the first cell and extend the selection with the mouse or keyboard. Then open Format > Merge and Unmerge Cells and choose the merge option you need. The menu includes a plain Merge Cells command and a Merge and Center Cells command; choose the latter only when centering the content is also what you want.

Select the cells that form one continuous rectangle, such as B1 through D1 for a heading spanning three columns.
Choose Format > Merge and Unmerge Cells > Merge Cells, or choose Merge and Center Cells if you want the remaining content centered.
Confirm any warning about contents if one appears, then inspect the merged cell and its alignment.

You can also find a merge control on Calc’s toolbar in many interface layouts. The menu is a dependable way to identify the command and distinguish plain merging from merging and centering. If you do not see the expected option, check that you selected multiple cells in one rectangular range rather than separate, nonadjacent cells.

Calc data: what is kept and what can be lost?

Calc’s merge behavior deserves special care. When a range is merged, the content of the upper-left cell is the content retained in the merged cell. Values or formulas in the other cells in the selected range can be discarded. A warning may appear, but do not rely on a prompt as your only safeguard: check the range before you merge it.

For instance, if A1 contains “Quarter” and B1, C1, and D1 contain values or formulas, merging A1:D1 does not combine those four entries into a single readable string. The upper-left cell’s content is what remains. If you need to preserve the other entries, copy them elsewhere or combine them deliberately before merging. If they are numbers that must remain usable in calculations, keeping them in separate cells is usually the better design.

A merged cell also affects how you select and work with the grid. It can make sorting, filtering, filling formulas, and selecting consistent ranges less straightforward, especially when merged cells occur inside the main data area. A common practical pattern is to merge a heading above a table while keeping the records below it in a regular, unmerged grid.

When merging is useful—and when it is not

Merging is most useful for presentation: a title spanning several columns, a form label spanning adjacent areas, or a Writer table cell that needs more room for a note. It can make a document easier to scan when the merged area has a clear purpose and the surrounding layout remains simple.

Consider alternatives when the cells hold data rather than labels. In Calc, use a heading in the first cell and center it across selected columns only if the available alignment options suit your layout; alternatively, place the heading in a separate row above the data. Keeping each data value in its own cell makes it easier to sort, filter, calculate, and export. In Writer, remove an internal border or change column widths if you want a visual effect without changing the table’s cell structure.

Before merging, ask whether you need one larger cell or merely a different appearance. A merged heading may be harmless in a small report, but merged cells scattered through a spreadsheet can make later maintenance harder. The choice is about both appearance and how you plan to use the document.

Common problems and how to fix them

Merge Cells is unavailable: In Writer, confirm that multiple adjacent cells are selected. In Calc, select a multi-cell rectangular range; a single cell or a noncontiguous selection is not a suitable range.
The wrong cells merged: Undo immediately with Ctrl+Z on Windows or Linux, then make the selection again. On macOS, use Command+Z. Undo is useful for an immediate correction, but it is not a substitute for checking Calc contents first.
Text or formulas disappeared in Calc: If the merge has not been undone, use Undo if possible. If you already made other edits, recover the values from a saved copy or re-enter them from another source. The merge does not turn the contents of every selected cell into one combined value.
The merged heading looks off-center: Merging and centering are distinct choices in Calc. Apply the desired alignment after merging, or use Merge and Center Cells when that is the intended result.
The table looks uneven after merging: Review cell borders, row height, column width, paragraph spacing, and text wrapping. A merged cell changes the available space, but it does not necessarily produce the final visual formatting automatically.

If the menu labels or layout look different, the application may be using a different user-interface arrangement or version. The commands can still be located through the menus named above; in a customized interface, toolbar placement may differ. Make sure the active window is Writer or Calc, since similarly named controls can behave differently in each application.

Layout, printing, and sharing considerations

Check merged cells in the final output, not just on screen. In Writer, a merged cell may change the table’s proportions and affect page breaks or the way text wraps. In Calc, a long heading in a merged range may display differently when column widths change or when the sheet is printed. Use print preview or export a test PDF if the exact page layout matters.

Keep accessibility and future editing in mind as well. A simple table with consistent rows and columns is generally easier to navigate and reuse than one with many irregular merged areas. For a document intended for others to edit, label the table clearly and avoid merging cells solely to imitate spacing that could be handled with widths, borders, or a separate heading.

Frequently Asked Questions

Can I merge cells in LibreOffice Writer?
Yes. Select adjacent cells in the table, then choose Table > Merge Cells or right-click and choose Merge Cells. Review the resulting text and formatting afterward.

Can I merge cells in LibreOffice Calc?
Yes. Select a rectangular range and choose Format > Merge and Unmerge Cells, then select Merge Cells or Merge and Center Cells.

Does merging cells in Calc combine all their text?
No. The upper-left cell’s content is retained; content in the other selected cells can be lost. Copy or combine anything you need to keep before merging.

Can I undo a merge?
Use Ctrl+Z on Windows or Linux, or Command+Z on macOS, immediately after the operation. Calc also has an Unmerge Cells command in the same Format submenu, but unmerging does not restore content that was discarded.

Can I merge non-adjacent cells?
No. A merge applies to a contiguous selection of neighboring cells, normally a rectangular range in Calc. For separate cells, change their formatting individually or arrange the table differently.

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.