But the problem with the Merge Across command is that while merging cells it only allows us to keep the content of the first cells among the selected cells.

The Merge Across command can merge all the cellswithin a single row. When you hit the final key which is C, you will see the title text has become center-aligned like this: After selecting the cells you have to press those keys one after another. So the shortcut keys for the Merge & Center are ALT > H > M > C. РІСњС” Press C to apply the Merge & Center command to the selected cells. РІСњв„– Then press M to go to the Merge & Center group.Р”Р„fter pressing the M key, you will see four more options regarding Merge & center. РІСњС‘ Press the key H to select the Home menu.

The Merge & Center command is located under the Home menu. To make the title of the table center aligned,Р”Р„t this point, you will see the hints of keyboard shortcuts that have appeared like the image below: This can be easily done using the Merge & Center. Here the title of the table is Book List which is located only on a single cell.Р”В«ut we can make the best fit of the title by putting it in the middle of the two columns. We have a data table of columns named Book List. Merge & center makes the title bar visually more appealing and also it makes more sense while creating a data table in a Microsoft Excel spreadsheet.Р”Р€ Shortcuts for Merge and Center in Excel 1. Primarily, merge & center is used to create a title bar to the data tables. Merging cells means concatenating a number of cells vertically or horizontally that allows us more space to insert contents.

Excel shortcut key to center text