There are four options available in Merge and Center:. H takes you to Home tab, M takes you to Merge and Center options and C selects the Merge and Center option.Īs we can see text in B1 cell is now merged and centered in B1 to D1 cells. The ALT key activates the ribbon and following keys take you to the Merge and Center option. This is not actually a shortcut to merge cells in excel but it is fast. Press and release ALT key, following by H, M, and C key on keyboard.To merge and center two or more cells follow these steps: Sequential Merge and Center shortcut in excel (ALT>H>M>C) The traditional way is lengthy and there is no simple shortcut to merge and center, like CTRL+C for copying. So when you work dashboards, you get the need for Merge and Center cells. This is used to combine multiple cells into a single cell and create the main headers for reports in Microsoft Excel. This is a great way to create a label that spans multiple criteria. Merge & Center combine and center the contents of the selected cells in a new, larger cell.
