Excel Cells Not Merging: 5 Ways to Fix This Issue

You can repair your workbook or try converting the table to range

by Sagar Naresh
Sagar Naresh
Sagar Naresh
Content Analyst
Sagar is a web developer and technology journalist. Currently associated with WindowsReport and SamMobile. When not writing, he is either at the gym sweating it out or playing... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • Merging cells makes a dataset look presentable and properly formatted.
  • However, often you won't be able to merge cells because the workbook is protected or it is shared.
  • You can first try to remove the protection or convert the table to a range.

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

MS Excel is a powerful tool that comes with a plethora of great features to represent or get meaningful information out of a dataset. Merging cells is another great feature when you want to format the heading or center just to present the dataset in a proper manner.

However, there are reports where users have complained that for them, Excel cells are not merging. In this guide, we will give you five solutions that will help you get rid of the issue. Let us check them out.

Why aren’t the MS Excel cells merging?

After some research, we have found a few reasons that might be restricting you from merging cells in your MS Excel spreadsheet:

  • Cells are within a table: This is one of the most common reasons because of why you are coming across MS Excel cells that are not merging issues. Excel table does not allow you to merge cells that are inside a table.
  • Your worksheet is protected: For safety reasons and to avoid people from editing your worksheet, chances are the worksheet that isn’t allowing you to merge cells is protected.
  • Your worksheet is shared: Do note that along with the protected worksheet, a shared worksheet will also not allow you to merge cells in Excel.

These are the three main reasons why you are facing MS Excel cells not merging issues.

What can I do if Excel cells are not merging?

Here are a few things that you can do before applying the advanced solutions:

  • Perform a simple restart. Often if the program fails to load all its files properly, then it can throw up multiple errors.
  • Check if you are running the latest version of MS Excel on your PC. This ensures that this error isn’t because of an old version or compatibility issue.
  • Make sure that the worksheet that you are working on isn’t corrupt and does not have incompatible values.

Now, let us take a look at the solutions that will help you resolve this problem.

1. Merge cells in a table using the context menu

  1. Select the entire table or click on any cell within the table.
  2. Right-click, select Table, and click on Convert to Range option from the context menu.
  3. Excel will show a confirmation window Do you want to convert the table to a normal range?
  4. Click Yes.
  5. Now select the cells that you wish to merge.
  6. Click on Merge & Center button at the top menu bar in the Home tab.
  7. Select Merge & center again from the drop-down menu.
  8. A pop will show you Merging cells only keeps the upper-left value and discards other values warning. Click Yes.
  9. You will see your selected cells are now merged.

2. Unprotect your workbook

  1. Open your workbook.
  2. Click on the Review tab.
  3. Click on Unprotect Worksheet and Unprotect Workbook.
  4. Select the cells that you wish to merge.
  5. Select Merge & Center button at the top menu bar in the Home tab.
  6. Click on Merge & center again from the drop-down menu.
  7. A pop will show you Merging cells only keeps the upper-left value and discards other values warning. Click Yes.
  8. You will see your selected cells are now merged.

The protected workbook will prevent you from editing, let alone merging cells. In such a case, you can follow the steps above and unprotect your cells.

Expert tip:

SPONSORED

Some PC issues are hard to tackle, especially when it comes to corrupted repositories or missing Windows files. If you are having troubles fixing an error, your system may be partially broken.
We recommend installing Restoro, a tool that will scan your machine and identify what the fault is.
Click here to download and start repairing.

Then you can follow solution 1 and convert the data to the range and then apply the merge function to merge the selected cells.

3. Unshare your workbook

  1. Open your workbook.
  2. Click on the Review tab.
  3. Under the Protect section, click on Unshare workbook option.
  4. Now you can go ahead and merge the cells.

4. Disable Add-Ins

  1. Open your workbook.
  2. Click on the File option at the top Menu bar.
  3. Select Options from the left panel.
  4. Click on Add-in.
  5. Make sure that the add-ins are disabled.
  6. Go back to your worksheet and check if you can merge cells or not.

Often add-ins can interfere with the smooth functioning of the MS Excel program. While we install add-ins to enhance the functionality of the program, they can cause issues such as Excel cells not merging problems.

In this case, we would suggest you disable all the add-ins by following the above steps and then trying to merge cells in your workbook.

5. Repair your workbook

  1. Launch MS Excel.
  2. Click on File.
  3. Click on Open.
  4. Select your file and from the Tools drop-down menu, select the Open and Repair option.
  5. Select Repair on the message that pops up.

Often workbooks get corrupted, or data in them get lost, which could be an issue if you aren’t able to merge cells in Excel. Simply follow the above steps, repair your workbook, and check if this resolves the issue or not.

These are some of the best solutions to apply when cells are not merging in MS Excel. Well, you will come across other issues with MS Excel as well.

For users facing Excel won’t scroll down errors, we have a guide that lists some effective solutions to resolve it. We also have a guide on the Excel toolbar missing to fix the issue.

Moreover, if you want to know how you can open two Excel side by side to improve efficiency, you can refer to our guide. Also, did you know that you can open multiple Excel files at once?

We also have a dedicated guide for those who aren’t able to open Excel on their Windows 11 PCs. Let us know in the comments below which one of the above solutions helped you fix the cells that are not merging in MS Excel.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: