RedditPP Mascot

RedditPP

r/excel • … • u/MayukhBhattacharya

RIP Merge & Center!!!!

Microsoft just added **Center Across Selection** right inside the **Merge & Center** menu. And truly, this one makes me very happy and excited because of what that button can help us to avoid.

**H̲ome** Tab --> **Alignment** Group --> **M̲erge & Center** Menu --> **Center Across S̲election**.

Using merged cells inside your actual data can cause all kinds of headaches with sorting, formulas, and selecting ranges. That's the problem with merged cells in your data. The feature itself isn't new. **Center Across Selection** has been around for a while. It was just buried inside **Format Cells**, so a lot of people probably never even knew it was there. Now it's right on the ribbon, which makes it way easier to find and use.

Some of you **might not see** it yet since Microsoft is rolling it out gradually. Once it shows up in your Excel, it's definitely worth getting familiar with.

**MS365 Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2610 Build 16.0.20508.20000) 64-bit**

Let me know what you think.

![gif](1d8tp62j32qh1 "Center Across S̲election")

— 0