In this video, I explain why using the Merge & Center button in Excel can cause you all sorts of problems.
I also show you the Center Across Selection feature, which accomplishes the same thing as Merge, but without any of the drawbacks.
When you merge cells, it stops you from selecting individual columns in your formulas. Which can cause a whole lot of difficulty for you as you try to build out your spreadsheets.
Instead, right click on the cells you want to merge, open the Format menu, go to the Alignment tab, and then in the Text alignment section, select the dropdown box for Horizontal, and choose “Center Across Selection.”
It will look exactly the same as when the cells are merged, but it won’t cause any problems in your formulas.
Watch the video to learn more.
Want to learn more about Excel?
Subscribe to our newsletter to get monthly tips on how Excel can make your life easier, and be notified of our courses.
You can also submit questions to be answered in a future blog post or video, or book a free consultation to find out how we can save your business time and money with our done-for-you solutions.