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.
Merge and center cells by normal shortcut keys
Merge and center cells by custom shortcut keys
Merge and center cells by adding the Merge &Center function to Quick Access Toolbar
Merge and center cells by normal shortcut keys
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.
Merge and center cells by custom shortcut keys
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.
Merge and center cells by adding the Merge &Center function to Quick Access Toolbar
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.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
