Add Center Across Selection to the Merge & Center Drop-down
Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?
Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.
Currently, the Merge & Center drop-down offers: Merge & Center, Merge Across, Merge Cells, UnMerge.
My request: Adding a fifth item of "Center Across Selection" to the drop-down.
As a bonus, add a tool tip explaining the perils of merged cells and how Center Across Selection is superior in nearly every way.
Thanks for voting!
Almir Jorge commented
Também sou contra a mescla de células.
Como opção, para quem precisa, sugiro usar "centralizar a seleção".
mark chalmers commented
I've always hated merge and centre, but I had no idea "centre across selection" even existed!
H Dum commented
Not being buried would be great.
Personally I'd still use merge cells, currently to cumbersome to center across some and merge others. Center across in not effective when you have text you've rotated vertically, and want it to go across multiple rows. Ex- have multiple items offered in several selections, but one item is not offered in one grouping of selections. Marge and center with vertical text Not Available.
@Monte Tucker Conditional formatting is under styles, which generally is on the ribbon. Conditional formatting pre-dates the ribbon. You can customize what color the cell is under what circumstance by defining the rule.
Agreed ... this is a brilliant option of which I was not aware until you explained it. I'm not a fan of Merge and Center at all, but use it (until now) begrudgingly. No more!
Khris F. commented
You are the real MVP of Excel users. I hate this issue and just accepted it as a limitation but your suggestion seems like a perfect solution to this.
Bill Young commented
You are my Elvis!
سمير حمتو commented
سمير حمتو commented
Better would be just to get rid of the button.
Bury the "feature" really deep somewhere,
so if we DO actually need it,
we will have to look for it.
Jan Karel Pieterse commented
A feature looooong overdue!
Joel Chojnacki commented
Amol Kumbhar commented
Great idea, agree with you
Haytham Amairah commented
Robin Miller commented
Votes, I agree
Mark Blackburn commented
Voted, it should be there
Kevin McLogan commented
A fine idea! I hate merged cells!
Gary Kane commented
Friends don’t let friends merge cells.
Jon Peltier commented
When 2007 came out, and Center Across Selection was missing, we complained. They said something like, oh, our data shows now people use merged cells, and by the way, it's too late to change. And nobody ever picked it up for later versions.
Chris Newman (The Spreadsheet Guru) has an add-in that adds a Center Across Selection button to the ribbon; I helped him fine-tune the ribbon XML (https://www.thespreadsheetguru.com/blog/add-center-across-selection-button-to-excel-home-tab).