How to merge and center cells by shortcut keys in Excel?
Normally, you can use the Merge &Center function from the ribbon to merge and center multiple cells together. But if you need to use this feature frequently, here, I will introduce some shortcut keys for solving this job.
Normally, there is a default shortcut (Alt > H > M > C sequentially) for merging and centering selected cells, please do as this:
1. Firstly, select the cells that you want to merge, then press Alt key, the letters will be displayed on the ribbon as below screenshot shown:
2. Then, press H key on the keyboard to choose the Home tab, and you can see the M letter below the Merge & Center feature, see screenshot:
3. And then, please go on pressing M > C successively to merge and center the selected cells.
If the above shortcut keys are too long to remember, here, you can create a custom simple shortcut keys for using.
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
Sub MergecenterCells() With Selection .HorizontalAlignment = xlCenter .Merge End With End Sub
3. Then save and close this code window, and go on pressing Alt + F8 to open the Macro dialog box, click Options button to go to the Macro Options dialog box, and then enter a customized shortcut key you would like, see screenshots:
4. And then, click OK and close the Macro dialog box, now, when you want to merge and center selected cells, you just need to press Ctrl + y (the shortcut keys you specified in last step) to solve it.
If you think the above methods are troublesome for using, here, you can add the Merge & Center feature into the Quick Access Toolbar.
1. Right click the Merge & Center, and select Add to Quick Access Toolbar option, see screenshot:
2. And then, the Merge & Center feature has been added into the Quick Access Toolbar, see screenshot:
3. From now on, you just need to click this feature from the Quick Access Toolbar to merge cells.
More relative merged clles articles:
- Filter All Related Data From Merged Cells In Excel
- Supposing there is a column of merged cells in your data range, and now, you need to filter this column with merged cells to show all the rows which are related with each merged cell as following screenshots shown. In excel, the Filter feature allows you to filter only the first item which associated with the merged cells, in this article, I will talk about how to filter all related data from merged cells in Excel?
- Auto Fit Row Height Of Merged Cells In Excel
- In Excel, we can quickly adjust the row height to the fit the cell contents by using the AutoFit Row Height feature, but this function will completely ignores merged cells. That is to say, you can’t apply the AutoFit Row Height feature to resize the row height of merged cells, you need to manually adjust the row height for merged cells one by one. In this article, I can introduce some quick methods to solve this problem.
- Clear The Contents Of Multiple Merged Cells In Excel
- If you have a large worksheet which contains multiple merged cells, and now, you want to clear all the contents of the merged cells but keep the merged cells. Normally, you may try to apply the Find and Replace function to select all merged cells first, and then press Delete key to delete the value, however, you will get a warning message "We can’t do that to a merged cell". In this case, how do you clear the values in merged cells but leave the merged cells quickly in Excel?
- Copy And Paste Merged Cells To Single Cells In Excel
- Normally, when you copy the merged cells and paste them into other cells, the merged cells will be pasted directly. But, you want to paste theses merged cells to single cells as following screenshot shown, so that you can deal with the data as you need. This article, I will talk about how to copy and paste merged cells to single cells.