Shortcut for Merge and Center in Excel
In the excel worksheet, Merging the cells is not a user-friendly option to navigate, but we still use it to fit the reported alignment. Many of the users often ask in the blog that what is the shortcut key to merge & center cells in excel. Unfortunately, there aren’t any default shortcut keys for this technique but no need to despair because we will use other shortcut keys to merge & center cells in excel. However, there are circumstances where we need to merge cells to make the report look neat and aligned properly. In this article, we will show you how to merge and make them center aligned using shortcut keys in excel.
How to Use Shortcuts for Merge & Center?
Below are the examples of excel shortcuts for merge and center.
#1 – Manual Method
- For example, look at the below data table.
We have a category-wise & month-wise summary. In the first row, we have category names “Sales” & “Cost,” but each category is not neatly aligned. Since the category belongs to both “Sales” & “Cost,” we need to make this a single header for these by merging the cells.
- Before we merge, we need to first select the value cell for cells we need to merge. In this case, we need to merge the “Furniture” category to B1 & C1 cells, so select B1 & C1 cells.
- Under the HOME tab, we have an option called “Merge & Center in Excel,” so click on this.
- This will instantly merge the selected cell and make the alignment as “Center.”
- As you can see now “Merge & Center” option is highlighted, which means the active cell is applied with a merge option. Similarly, we have the other two categories to merge, so repeat the same action for the other two.
Once the “Merge & Center” formatting applied for the first category cell for the other two, we need not use the “Merge & Center” formatting option again. Instead, we can simply use the F4 function key.
- After merging first category cells next select second category cells.
- Now press the F4 key to repeat the previous action of “Merge & Center.”
- Do the same thing for one more category as well.
#2 – Using Shortcut Key (ALT + H + M + C)
Manual methods are to start the things off, but after a while, you must start using excel shortcut keys to work efficiently. There is no default shortcut key to “Merge & Center,” but let’s discover it now.
Follow below steps to merge and center cells in excel using shortut key.
- Press the ALT key to highlight the short cut alphabets for each ribbon.
- Since the Merge and Center option is available under the HOME tab, press “H” to go inside the “HOME” tab.
- Upon pressing the “M” key, it has opened up other options of “Merge and Center.” From these lists, we need to select the option of “Merge and Center,” so the shortcut key is “C”
- Shortcut key to merge & center:
Other Option of Merge
As you can see above, we have four different options under “Merge & Center,” let’s see what those options are.
- Merge & Center: This will merge the selected cells into one and make the alignment of the text in the cell as the center. Shortcut is “ALT + H + M + C”.
- Merge Across: This will merge the selected cells into one and make the alignment of the text in the cell as right. Shortcut is “ALT + H + M + A”.
- Merge Cells: This will only merge the selected cells into one. Shortcut is “ALT + H + M + M”.
- Unmerge Cells: This will do the reversal of above all; this will unmerge all the merged cells. Shortcut is “ALT + H + M + U”.
Case Study of Merge & Center
- Let’s look at this case study of Merge & Center.
“Q1” is for the first three months, Q2 is for the second three months, and so on. Assume we need to merge Q1 to the first three cells, Q2 to the next three cells, and so on, doing these four times will not take more time, but there are instances where we need to do it 100 times, in those cases, this technique is very important.
- First, merge three cells.
- Now double click on “Format Painter in ExcelFormat Painter In ExcelFormat painter in Excel is a tool used to copy the same format of a single cell or a group of cells to the other cells. You will find it on the home tab in the clipboard section.“ by selecting the merged cell.
- Now keep pressing the down arrow key until the cell you reach the merging of cells. In this case, we need to press down arrow three times to apply the same formatting to other quarters as well.
So all the cells merged with the same alignment.
Like this in the case of cells with equal merging options, we can use this technique.
Things to Remember here
- In the case of merging multiple times of the same cell length, we can use format painter to avoid unnecessary steps.
- In case merging cells have values in it, then it will ask your permission before merging.
This has been a guide to Excel Shortcut for Merge and Center. Here we discuss how to do the merge and center-alignment to the cells using shortcut keys in excel along with practical examples and downloadable excel templates. You may also look at these useful functions in excel –