Besttechindia is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Learn more.

How To Merge Cells In MS Excel (2020)

Edited By Piyush Kashyap, Reviewed By Gulshan

There is hardly any business organisation that does not Microsoft Office for their day-to-day tasks. And why just businesses, from students to researchers, everyone faces this need to use Microsoft from time to time.

Within the Microsoft Office, MS Excel is one of the most used software. It is a spreadsheet program that is used for storing, utilising and analysing data. It is one of the best tools to keep records to track business or estimates. 

It is one of the most common tools used by businesses irrespective of their industry. Its fame lies not in the fact that it monopolizes the spreadsheet software industry (if one can call it that), but in the fact that it is the oldest and one of the most easily available programs. 

How To Merge Cells In MS Excel (2020)

One of the most common functions of MS Excel is merging and unmerging of cells. While it is not a complex process, it still is a little bit difficult. But we have tried to make this problem easier in this blog. 

In this blog, we will cover the different ways to merge and unmerge cells on different platforms and operating systems. However, before we explore the process of merging and unmerging cells, there is a caveat you need to know about.

When merging more than two cells, Excel by default deletes the data of other cells and restores the date of the first cell. Now that you know about this, it's time we explore the ways to merge cells in MS Excel.

Merging the cells

  • Merging cells in the center: Select the cells you want to merge and then on the toolbar find the ribbon “Merge and Center”. Select this option, and the cells will be merged in the center.
  • Merging cells across: If you want to merge the cells located across the spreadsheet, then highlight those cells and go to “Merge and Center” on the toolbar. Once you are there, click on the arrow and select “Merge Across”. Once you select that tab, your job is done.
  • Merging Cells: Highlight the cells you want to merge and go to the “Merge and Center” option on the toolbar. Once you are there, click on the arrow and select “Merge Cells”. Once you do this the content of the first cell will be displayed on the left-most corner of the cell. 

Unmerging the cells

Unmerging cells is as easy as merging them. However, before you go ahead with this, remember that on unmerging you will lose the content of the cells.  The steps to unmerge the cells are:

  1. 1
    Select the cells you want to unmerge.
  2. 2
    On the toolbar, click on the arrow beside the “Merge & Center” option.
  3. 3
    From the dropdown list, select the unmerge option and you are done

Please note that, while you can merge many cells into one, you cannot split one cell into many cells.

If you want to distribute the content of the cell into more than one cells, then follow these steps:

  1. 1
    Highlight the required cells.
  2. 2
    In the Data tab, go to the “data tools” group.
  3. 3
    Then click on the “Text to columns” option and follow the instructions that come on screen.
  4. 4
    Then you will reach the “convert text to column wizard” tab, here you have to specify the pattern of division in different columns.
  5. 5
    Once you do that, your cells would be split according to how you wanted.

How To Merge Cells In MS Excel

How Mac users can merge the cells in excel

The procedure for Mac users to merge the cells in the spreadsheet is a bit different. Let’s have a look at the steps:

  1. 1
    Select the cells you wish to merge.
  2. 2
    Then right-click and select format cells.
  3. 3
    In the new window that opens, select the merge cells option from the alignment tab.
  4. 4
    Click ‘Ok’ and your cells would be merged.

How can users merge cells in Excel Web App?

The steps are more or less similar as the desktop app. Select the cells that you want to merge and click on the“Merge & Center” option. From the drop-down list select any option you prefer and you would be good to go.


Follow me here

About the Author

Piyush Kashyap is a Ph.D student at Sant Longowal Institute of Engineering and Technology, Sangrur. He is a budding editor/ writer and has been working as a part-time reviewer for online content. He loves to read tech-based articles and has a knack for reviewing such articles He likes to stay updated about the latest trends in technology. He has also been working as a reviewer for many scientific journals. He also writes articles based on science. Know More About Piyush

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}