Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles CONDITIONAL FORMATTING How to merge and center cells in Excel – Excelchat

How to merge and center cells in Excel – Excelchat

We can combine and center the contents of selected multiple cells inside a new and larger cell with the merge and center shortcut in Excel.

When cells are merged, only the content of the upper-leftmost cell is preserved. “Center” implies that it allows for alignment of cell data to be centered.

Figure 1. of Merge and Center in Excel

How to Use Merge and Center in Excel

  1. We start by selecting the adjacent cells we want to merge in our worksheet:

Figure 2. of Merge Cells in Excel

  1. Click on the “Home” icon, and then go to “Alignment” group, click on the “merge and center” button;

Figure 3. of Merge and Center in Excel

The merge and center function in excel will combine the selected data in one large cell;

Figure 4. of Merge and Center in Excel

Note that the text becomes centered in worksheet example above screenshot.

Excel Merge Cells Shortcut

We will now demonstrate how to use the keyboard shortcut to merge cells in Excel with the following simple steps;

  1. We start by selecting those cells which we seek to merge and center via shortcut and then press the “ALT” keyboard key which toggles the keyboard commands on an Excel ribbon;

Figure 5. of Merge Cells Shortcut in Excel

  1. Press the “ALT+H” keyboard keys to select the “Home” tab on the Excel ribbon; this will enable the” Home” tab menu of Excel. Then press the “M” (keyboard shortcut) which enables the Excel “Merge & Center” option.

Figure 6. of Merge Cells Shortcut in Excel

  1. We can make use of any of these keyboard shortcuts to merge cells in Excel:
  • Press the “A” key to merge cells within a separate individual row.
  • Press the “C” keyboard key, is the shortcut to merge cells in Excel after selecting them.
  • The “M” keyboard key is the shortcut to merge cells in Excel without a centered alignment.
  • Press the “U” keyboard key, to unmerge those already merged cells.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc