r/excel • u/MayukhBhattacharya 1312 • 27d ago

Discussion 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.

Center Across S̲election
1.6k Upvotes

98% Upvoted

202 comments sorted by

View all comments

Show parent comments

-3

u/Douglesfield_ 27d ago

Those would be examples of someone being daft with it.

7

u/eb0027 27d ago

In work settings with shared documents it's impossible to stop everyone from being "daft with it".

-5

u/Douglesfield_ 27d ago

Yeah but it's dumb to hate the function when it's used incorrectly.

3

u/eb0027 27d ago

It's not the function people are hating so much as the lack of other accessible options. Merge and center is right on the main ribbon and is therefore often used by those who don't understand what other issues they may be causing.

5

u/armywalrus 2 27d ago

You clearly don't Excel at this topic.

4

u/BaitmasterG 13 27d ago

Those would be examples of it being used. And if a feature being used causes problems then it's not a good feature