Cells won't merge in Microsoft Excel when the data is inside a table or when the workbook is protected or shared.

If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

Learn how to open an XML File in Excel, Word, Chrome, and Edge on a Windows computer using the methods mentioned in this post.