WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Shortcut for Merge and Center

Excel Shortcut for Merge and Center

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

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.

You can download this Shortcut for Merge and Center Excel Template here – Shortcut for Merge and Center Excel Template

#1 – Manual Method

  • For example, look at the below data table.

Excel Shortcut for Merge and Center Example 1

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.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • 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.

Example 1.1

  • Under the HOME tab, we have an option called “Merge & Center in Excel,” so click on this.

Excel Shortcut for Merge and Center Example 1.2

  • This will instantly merge the selected cell and make the alignment as “Center.”

Example 1.3

  • 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.

Excel Shortcut for Merge and Center Example 1.4

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.

Example 1.5

  • Now press the F4 key to repeat the previous action of “Merge & Center.”

Excel Shortcut for Merge and Center Example 1.6

  • Do the same thing for one more category as well.

Example 1.7

#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.

  • Press the ALT key to highlight the short cut alphabets for each ribbon.

Excel Shortcut for Merge and Center Example 1.8

  • Since the “Merge & Center” option is available under the HOME tab, press “H” to go inside the “HOME” tab.

Example 1.9

  • Now it has highlighted the shortcut key for all the tools under the home tab. For “Merge & Center,” we can see the option as “M,” so press the “M” key.

Excel Shortcut for Merge and Center Example 1.10

  • Upon pressing the “M” key, it has opened up other options of “Merge & Center.” From these lists, we need to select the option of “Merge & Center,” so the shortcut key is “C.”
  • Shortcut key to merge & center:

Excel Shortcut for Merge and Center Example 2.4

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.

Excel Shortcut for Merge and Center Example 2.0

“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.

Example 2.1

  • Now double click on “Format Painter in Excel“ by selecting the merged cell.

Excel Shortcut for Merge and Center Example 2.2

  • 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.

Example 2.3

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.

Recommended Articles

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 –

  • Column Merge Excel
  • Shortcut to Select Excel Row
  • Merge Tables Excel
  • Unmerge Cells in Excel
18 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Category iconExcel Tutorials,  Excel, VBA & Power BI

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Shortcut for Merge and Center Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More