How To Combine Multiple Cells

Table of contents:

How To Combine Multiple Cells
How To Combine Multiple Cells

Video: How To Combine Multiple Cells

Video: How To Combine Multiple Cells
Video: Combining Data From Multiple Cells in Excel 2024, March
Anonim

Concatenating cells is one of the functions used when creating a table. It means creating one cell from two or more selected cells. This function is used in both Word and Excel.

How to combine multiple cells
How to combine multiple cells

Instructions

Step 1

You created a table in a Microsoft Word document and while entering data, you needed to combine two or more cells into one. When you create a table, the Design and Layout tabs appear in the top menu. While holding down the left mouse button, select the required cells. Go to the "Layout" tab, then to the third group from the left "Combine".

Step 2

Click the Merge Cells button. Alternatively, right-click on the selected cells and select "Merge Cells". All data from the selected rows and columns will be arranged in one column.

Step 3

If you need to undo the merging of cells, click on the "Undo Input" button in the upper left corner, or the keyboard shortcut Ctrl + Z.

Step 4

In a Microsoft Excel sheet, the merging of cells is different. If the data is contained in several cells to be merged, only the data in the upper left or upper right cell will be saved (depending on the direction of viewing at the moment), while the rest of the data will be deleted.

Step 5

Select the cells to be merged. Right-click on the selected sector. Select Format Cells. Click the Alignment tab. In the "Display" box, check the box "Merge cells".

Step 6

In this case Excel will issue a warning: “The selected area contains several data values. Merging cells will result in the loss of all values except the top left."

Step 7

You can also merge cells on the Home tab in the Alignment group. Click on the arrow in the lower right corner. The Format Cells window opens. Repeat the steps above.

Step 8

You can edit the union. On the Alignment tab, click the arrow next to the a-shaped button. In addition to merging, cells are offered here "Merge and Place in the Center", "Merge by Rows". The bottom button "Undo Cells Merge" will undo the merge, but will not return the data that was in separate cells.

Step 9

To undo the merge and return data, click the Undo Input button, or the keyboard shortcut Ctrl + Z.

Recommended: