Excel Error “You can’t enter an array formula over merged cells” You created a cool array formula and then merged it across several cells. Later, you realize that you need to modify this array formula. When you try to press Control Shift Enter you get this horrible error: Continue reading →