Merge and Unmerge Cells in MS-Excel
Merge and Unmerge Cells in MS-Excel
Merge and Unmerge Cells: Combining more cells into one cell is called Merge cell. Similarly, dividing a cell into multiple cells which are merged, called Unmerge Cells. The lesson on Merging and Unmerging Cells is discussed below.
Merge and Unmerge Cells in MS-Excel
1. Merge & Centre:
Combining more cells into one cell and centering the text is called the Merge & Centre.
Go to the Home tab
Select the range of cells and enter the text that you want to merge and center the text
Then click on the drop-down arrow of the Merge and Center
Afterwards, select Merge and Center in the Alignment group
Merge and Unmerge Cells in MS-Excel
5. Look at the 5th step of a picture below, in which the cells merged and the text centered.
Merge and Unmerge Cells in MS-Excel
Click to Learn about >> Introduction to MS-Excel Spreadsheet Environment
Click to Learn about >> How to copy text as a picture in Excel.
2. Merge Across:
Merging cells by combining Vertical lines and leaving horizontal lines to merge across the selected cells.
- Select the range of cells that you want to merge across
- Then go to the Home tab
- After that, click the drop-down arrow, which appears at the right of Merge & Center In the Alignments group.
- And then select Merge Across
Merge and Unmerge Cells in MS-Excel
5. Now look at the 5th step of a picture below, in which the cells are merged across.
Merge and Unmerge Cells in MS-Excel
3. Merge Cells (Merge and Unmerge Cells in MS-Excel):
Combining more cells into one cell is called Merge Cells.
- Select the range of cells that you want
- On the Home tab, in the Alignments group, click the Drop-down arrow which appears at the right of Merge & Center and then select Merge Cells.
4. Unmerge Cells (Merge and Unmerge Cells in MS-Excel)
Divide a cell into multiple cells which were merged, called Unmerge Cell.
- Select the range of cells that you want
- On the Home tab, in the Alignments group, click the Drop-down arrow which appears at the right of Merge & Center and then select Unmerge Cells.
Thank you