Center Across Selection instead of Merge and Center.
Instead of using Merge and Centre, try using Merge Across Selection. It makes highlighting easy and formulas more logical. The results look the same, but what is happening in the background is different. Below is how most people will put a title across multiple cells, by using the Merge & Center button. Notice the green […]