< Documentation‎ | OOo3 User Guides‎ | Writer Guide

Merging and splitting cells

PowerPoint - Table Merge and SplitWatch More Videos at: By: Mr. Sometimes the information in our tableis not always a perfect grid of rows and columns.There are lots of reasons we might needto combine two or more cells, or divide one cell into two.Fortunately, InDesign makes it very easyto do this using the Merge and Split Cell commands.Let's take a look.I'm going to start by selecting two cells.To Merge them, I can. Merging Table Cells Merging table cells combines adjacent cells into one, eliminating the borders so that they behave as a single cell. To merge table cells: 1 Select a group of two or more adjacent table cells. The group of cells you choose must form a rectangle, and they must be all body cells, all header cells, or all footer cells. 2 Do either of the following: Choose Format Table Merge. 3) Merging cells using Excel’s Flash Fill feature. Flash fill feature was added to Excel in 2013 version. This is a very good tool to use to merge cells. Let’s merge the first name and last name using Flash Fill feature. Again, create a new column after the Last Name and name this new column as Full Name. Select the range that you want to merge, and click Kutools Combine. See screenshot: 2. In the Combine Columns & Rows dialog box, specify the options as below screenshot shown: (1) Select Combine rows under To combine selected cells according to following options. (2) Specify a separator for the combined data.

To merge a group of cells into one cell:

Select the cells to merge.
Right-click and select Cell > Merge on the pop-up menu, or select Table > Merge Cells from the menu bar.

To split a cell into multiple cells:

Position the cursor inside the cell.
Right-click and select Cell > Split on the pop-up menu, or select Table > Split Cells from the menu bar.
Select how to split the cell. A cell can be split either horizontally (create more rows) or vertically (create more columns), and you can specify the total number of cells to create.

It is generally a good rule to execute merging and splitting of cells at the end of the layout formatting. This is because some operations such as deleting a column or a row may produce a result difficult to predict when applied to a table with merged or split cells.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).

Retrieved from 'https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Writer_Guide/Merging_splitting_cells&oldid=141834'

This article is based on legacy software.

When working with tables, you may occasionally want to merge two or more cells, or split one cell into multiple cells. Word makes this easy.

Merging Cells

Cells can be merged either from the Quick Menu or the Ribbon.

HINTS:
To avoid having to redo your table headings, use the merge and split features as the final step in formatting your table.
If there is text in more than one of the cells being merged, the text from each cell will be separated by paragraphs in the resulting cell.

Merging Cells: Quick Menu Option

Select the cells you want to merge
Right click within the selected cells » select Merge Cells
The selected cells are merged.

Merging Cells: Ribbon Option

Select the cells you want to merge
From the Ribbon, select the Layout command tab
In the Merge group, click MERGE CELLS
The selected cells are merged.

Splitting Cells

As with merging, cells can be split from either the Quick Menu or the Ribbon.

Splitting Cells: Quick Menu Option

HINTS:
Word will attempt to evenly divide any text in the cell you are splitting based on the number of paragraphs.
You can only split one cell at a time using the Quick Menu option.

Select the cell you want to split
Right click within the selected cell » select Split Cells...
The Split Cells dialog box appears.
In the Number of columns and/or Number of rows boxes, type or use the nudge buttons to select the desired number of rows and/or columns
Click OK
The selected cell is split according to your settings.

Splitting Cells: Ribbon Option

Merging And Splitting Cells Keynote 2016

Select the cell(s) you want to split
NOTE: Unlike the Quick Menu option, using the Ribbon option allows you to split multiple cells at once.
From the Ribbon, select the Layout command tab
In the Merge group, click SPLIT CELLS
The Split Cells dialog box appears.
In the Number of columns and/or Number of rows boxes, type or use the nudge buttons to select the desired number of rows and/or columns
(Optional) If you are splitting multiple cells, to keep cell information that is in consecutive cells on the first selected row of new cells, select Merge cells before split
OR
To keep the information in individual cells in their original cells after splitting (rather than keeping the information in consecutive cells on the first selected row), deselect Merge cells before split
Click OK
The selected cell is split according to your settings.