shortcut for merge and center in excel 2016

These Communities are not intended to serve as 'chat rooms'.Īdditionally, my 'comment' was not that merged cells are not useful.

That's why it was split from the original thread & illustrates just a few reasons why 'me too' messages should not be interjected as a Reply into another user's conversation. Please reread that message & you'll see that the question expressly refers to Excel 2016. Why the Community moderator retained the reference to Word in the Subject I have no idea, but this conversation has been in the Mac Excel forum since the day it was posted. My reply was to the January 21 question tacked on to the original posting by I sure wish Microsoft had put someone in charge of this task during the development of the Office Suite since 2006. Supposedly, at the height of its popularity there was a person on every project team at Palm whose job it was to count the stylus inputs required to accomplish every task. I never owned a Palm Pilot, but friends of mine did. Layout options, then (c) click Split cells, then (d) move my hand back to the keyboard. Or (a) move my hand from the keyboard to the mouse, then (b) do 1 or 2 mouse clicks to display the Table But most of the time, I have to use four key presses to bring it up (Alt-release, J, L, P). Starting with 2007, that keystroke still works, but it is not shown anywhere in the interface.Įvery so often, my fingers remember where it is, and I press it. What's more, there is a shortcut key that opens the Split Cells dialog box. If we need to merge cells, then we need to merge cells, and Word provides a way to do it. Your comment about merged cells not being useful is irrelevant. The question was about a Word table, but your answer is about Excel.

Shortcut for merge and center in excel 2016