Press the “U” keyboard key, to unmerge those already merged cells.The “M” keyboard key is the shortcut to merge cells in Excel without a centered alignment.Select Continue with the current selection and hit Remove Duplicates. Keep selecting the content in Column C and click Remove Duplicates in Data tab. You can do it by clicking the Column Header A, pressing Ctrl+C, and clicking Column Header C or the cell C1 then pressing Ctrl+V. Right click the Merge & Center, and select Add to Quick Access Toolbar option, see screenshot: 2. If you think the above methods are troublesome for using, here, you can add the Merge & Center feature into the Quick Access Toolbar.
We will now demonstrate how to use the keyboard shortcut to merge cells in Excel with the following simple steps Note that the text becomes centered in worksheet example above screenshot. The merge and center function in excel will combine the selected data in one large cell Click on the “Home” icon, and then go to “Alignment” group, click on the “merge and center” button.We start by selecting the adjacent cells we want to merge in our worksheet:.of Merge and Center in Excel How to Use Merge and Center in Excel
“Center” implies that it allows for alignment of cell data to be centered.įigure 1. When cells are merged, only the content of the upper-leftmost cell is preserved. We can combine and center the contents of selected multiple cells inside a new and larger cell with the merge and center shortcut in Excel. How to merge and center cells in Excel – Excelchat