Skip to content

DigiRuns

Surpass Technical Knowledge

Menu
  • Home
  • Fundamentals
  • Digital Marketing
    • WordPress
    • Web Design and Development
  • Microsoft Office
    • Microsoft Word
    • Microsoft Excel
    • Microsoft PowerPoint
Menu

Home » Microsoft Excel » How to Merge or Unmerge Cells in MS-Excel – 2022

How to Merge or Unmerge Cells in MS-Excel – 2022

Posted on 12/04/201912/01/2022 by DigiRuns

Merging cells is the process of combining more cells into one cell. Similarly, dividing a cell into multiple cells is called unmerge cells.

Merge and Unmerge Cells in Excel
Merge and Unmerge Cells in Excel

1. Merge & Center:

Combining more cells into one cell and centring the text is called the Merge & Centre.

  1. Go to the Home tab
  2. Select the range of cells and enter the text that you want to merge and center the text
  3. Then click on the drop-down arrow of the Merge and Center
  4. Afterwards, select Merge and Center in the Alignment group
Merge and Center in Excel
Merge and Center in Excel

5. Look at the 5th step of a picture below, in which the cells are merged and the text centred.

Merge and Center-in excel
Merge and Center in excel

Click to Learn about >> Introduction to MS-Excel Spreadsheet Environment

See also  How to Change Cell Color Based on Value in Excel

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.

  1. Select the range of cells that you want to merge across
  2. Then go to the Home tab
  3. After that, click the drop-down arrow, which appears at the right of Merge & Center In the Alignments group.
  4. And then select Merge Across

The next step continues below the screenshot……

Merge Cells Across in excel
Merge Cells Across in excel

5. Now look at the 5th step of the screenshot below, in which the cells are merged across.

Merge cells across in excel
Merge cells across in excel

3. Merge Cells:

Combining more cells into one cell is called Merge Cells.

  1. Select the range of cells that you want
  2. 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.
See also  How to Use Total Formula in Excel - 2022's Secret

4. Unmerge Cells:

 Divide a cell into multiple cells which were merged, called Unmerge Cell.

  1. Select the range of cells that you want
  2. 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.

Related topics:

  1. Introduction to MS-Excel Spreadsheet Environment
  2. Clear Formats, Contents, Comments and Hyperlinks in Excel.
  3. Change Worksheet Tab Color in 4-Ways in MS-Excel
  4. 4-Ways to Rename a Worksheet in MS-Excel
  5. Home Tab in MS-Word 2019 – (Office 360)- The Big.

FAQ:

What is merge and unmerge cells in Excel?

Merging cells is the process of combining more cells into one cell. Similarly, dividing a cell into multiple cells is called unmerge cells.

See also  How to Add Zeros Before a Number in Excel - 2022's Best

Recent Posts

  • MS Paint Shortcut Keys- Download PDF Files for Free – 2022
  • Computer Memory for Short Term Storage – Gift in 2022
  • How to Enable Missing Theme Editor and Plugin Editor in WP
  • (A-Z) Change Text Direction (Rotate, Flip or Mirror) in Word
  • How to Make a Transparent Text Box or Shape in Word
  • How to Insert a New Page in Word in 3 Ways – 2022
  • What is Menu Bar in MS Word? (Professional and Office 360)