![shortcut for merge and center in excel shortcut for merge and center in excel](https://thesmartmethod.com/wp-content/uploads/2018/07/keyboard-shortuct-for-merge-and-center-1.png)
Press the Enter key to cancel the Edit mode, and then try to merge cells. If the Merge and Center button is greyed out, most likely the selected cells are in Edit mode.
#Shortcut for merge and center in excel how to#
If you are looking to combine two or more cells with data in them, check out How to merge cells without losing data.
![shortcut for merge and center in excel shortcut for merge and center in excel](https://i.ytimg.com/vi/ZTAoDCUCiw0/maxresdefault.jpg)
Make sure that all the data you want to include in a merged cell is entered in the left-most cell of the selected range because only the content of the upper-left cell will survive after merging, data in all other cells will be deleted.When using Excel's built-in features to combine cells, there are a few things to keep in mind: Excel's merging features - limitations and specificities To change the text alignment after merging, simply select the merged cell and click the desired alignment in the Alignment group on the Home tab.
![shortcut for merge and center in excel shortcut for merge and center in excel](https://cdn.ablebits.com/_img-blog/merge-cells/shortcut-merge-cells-excel.png)
Once you click Merge and Center, the selected cells will be combined into one cell and the text is centered like in the following screenshot: In this example, we have a list of fruits in cell A1 and we want to merge it with a couple of empty cells to the right (B2 and C2) to create a large cell that fits the entire list.