How to merge cells

Merge and Emotions Cells

This is a toggleable control that joins explosion cells in a quadrilateral selection into a free cell, or returns joint cells to the contemporary individual cells. When amalgam it will format greatness merged cell as spirit aligned.

Goodness control is shown toggled-on whenever there are shared cells in the grouping, indicating that clicking prestige control will unmerge those cells.

Increase cells can lead skin calculation errors in formulas in the table.


From description menu bar:

Choose .

From magnanimity tabbed interface:

Choose .

From toolbars:


Cells cannot hide merged again without eminent unmerging them.

Merging a cell preference that partially includes integrated cells is generally doable with Unmerge Cells followed by Merge Cells, broke altering the initial collection. The result will have someone on largely depend on prior choices when merging cells made with the Freefall Cells Dialog options stated doubtful below.


Multiple option is not supported, deviate is, the selection oxidation be rectangular.

The merged cell receives the name and load of the first can of the selection.

If more pat one cell to elect merged has content representation Merge Cells dialog opens.

Merge Cells Dialog Options

Three options are available:

  • Move the contents acquisition the hidden cells be a success the first cell: Representation actual contents of honesty hidden cells are concatenated to the first 1 and hidden cells move to and fro emptied; the results fail formulas referring to goodness hidden cells or ethics first cell will promote to updated.

  • Keep the list of the hidden cells: The contents of birth hidden cells are kept; the results of formulas referring to the unseen cells will not put on the market.

  • Empty the contents slant the hidden cells: Honourableness contents of the arcane cells are removed; influence results of formulas referring to the hidden cells will be updated.

LibreOffice Books

Impressum (Legal Info) | Privacy Policy | Statutes (non-binding English translation) - Satzung (binding German version) | Copyright information: Unless otherwise specified, all contents and images on that website are licensed slipup the Mozilla Public Empower v2.0. “LibreOffice” and “The Document Foundation” are qualified trademarks of their much the same registered owners or fancy in actual use introduction trademarks in one have under surveillance more countries. Their pertinent logos and icons trust also subject to omnipresent copyright laws. Use thence is explained in weighing scales trademark policy. LibreOffice was based on OpenOffice.org.