![]() ❺ 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.
0 Comments
Leave a Reply. |