Merge and Center in Excel

Excel has a unique button called “ Merge & Center, ” which is used to merge two or more different cells. When data is inserted into any unite cells, it is in the center put ; therefore, the name “ Merge & Center. ” On re-clicking on the button, it unmerges the cells. The value in the cell merged is located on the initial beginning cell in the worksheet .

Merge and Center Cells in Excel

Merge and Center in Excel – Merge cell is a routine in database program that enables different nearby cells to be joined into a unmarried larger cell. It is finished by choosing all cells to be merged and picking the “ Merge Cells ” decree. Center means that it enables text alignment to be in the center .

How to Use Merge and Center in Excel?

Following are the steps used to merge and plaza in Excel :

  1. First, select the adjacent cells you want to merge.
    Merge and Center Example 1
  2. On the “Home” button, go-to the “Alignment” group and click on “Merge & Center” in Excel.
    Merge and Center Example 2
  3. Click on the “Merge & Center” in Excel to combine the data into one cell.
    Merge and Centre Example 3
  4. Once you click “Merge & Center,” selected cells get combined into one cell, and the text comes in centered like the above screenshot.

Shortcut for Merge and Center Cells in Excel

#1. Select the cells which you want to merge and center using a shortcut Merge And Center Using A Shortcut There is no default shortcut key for “ Merge & Center ” in excel. But we have one shortcut that is “ Alt + H + M + C ”. First weigh “ Alt ” key it highlights the shortcut alphabets for each Ribbon, then Press “ H ” key as “ Merge & Center ” option is in Home check, then press “ M ” key to select “ Merge & Center ” option there you will see more different shortcut key from that Press “ C ” for center Alignment. read more .
#2. Press the “ Alt ” keystone that enables the commands on the Excel decoration.

Shortcut for merge and center cell step 1
#3. Press “ H ” to select the “ Home ” yellow journalism in the Excel ribbon Excel Ribbon The ribbon is an element of the UI ( User Interface ) which is seen as a plunder that consists of buttons or tabs ; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel 2007. read more. It allows the “ Home ” tab of Excel .
#4. Press “ M ” ( shortcut ) to allow the “ Merge & Center ” option in Excel .
Shortcut for merge and center cell step 2
#5. Press any one of the take after keys :

  • 6. Press “C” (shortcut) if you want to merge and center the selected cells in Excel.
  • 7. Press “A” if you want to merge cells in a separate individual row.
  • 8. Press “M” if you want to merge the cells without centering the alignment.
  • 9. Press “U” if you want to unmerge the already merged cells.

Other Merging Options in Excel

other merging option

  1. Merge Across: This option combines the selected cells in each row individually.
  2. Merge Cells: This option joins the selected cells into a single cell without entering the text in the cell.
  3. Merge and Center: This option enables us to merge the cell and align the text into the center.

Things to Remember

  • If you use any formulas using the merged cell, ensure to unmerge the cell before using any formula.
  • While merging any cell, check the right and left side data in a cell because once you combine the cell, it automatically deletes the data from the adjacent cell.
  • We cannot merge the cell separately if you merge cell A1 to D1. So it will be called cell A1 after merge and center.
  • After merging the cell, select the merged cell and tap the ideal alignment in the “Alignment” group on the “Home” tab to change the text alignment after merging the cell.

cells ok

  • After clicking “OK,” click on “Find All.” It will give you a result at which column cells are merged.

F ind All

This article is a guidebook to Merge and Center in Excel and its shortcut. We discuss how to merge and center in Excel using the menu and excel shortcut, hardheaded examples, and downloadable Excel templates. You may besides look at these utilitarian functions in Excel : –

source :
Category : Tutorial

Related Posts

Trả lời

Email của bạn sẽ không được hiển thị công khai.