ExcelExplained

How to unmerge cells in Excel

This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide...

How to use INDEX and MATCH functions in Excel for complex lookup

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.

Fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### Excel errors

Learn how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM, #VALUE, and ##### errors in Excel (practical examples included).

Category - Excel formulas

How to unmerge cells in Excel

This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide...