Merge and Center Cells in Excel

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

How to Use Merge and Center in Excel?

Shortcut for Merge and Center Cells in Excel

#1. Select the cells which you want to merge and center using a shortcutMerge And Center Using A ShortcutThere is no default shortcut key for “Merge & Center” in excel. But we have one shortcut that is “Alt + H + M + C”. First press “Alt” key it highlights the shortcut alphabets for each Ribbon, then Press “H” key as “Merge & Center” option is in Home tab, 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.

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

#2. Press the “Alt” key that enables the commands on the Excel ribbon.

#3. Press “H” to select the “Home” tab in the Excel ribbonExcel RibbonThe ribbon is an element of the UI (User Interface) which is seen as a strip 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.

#5. Press any one of the following keys:

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

  • Merge Across: This option combines the selected cells in each row individually.Merge Cells: This option joins the selected cells into a single cell without entering the text in the cell.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.

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

  • After it merges the text, select the merged cell and tap the desired arrangement in the “Alignment” group on the “Home” tab to change the content arrangement.Ensure that the information you need to Excel cell merge and center is in the upper-left cell, and remember that it will erase all information in the other merged cells. To hold any information from those different cells, copy it somewhere else in the worksheet before merging them.Select as many rows as you want. However, not more than one column. Likewise, ensure adequate void segments to one side to erase none of your information. Just include empty rows if it is important to be added.If, by any chance, “Merge & Center” is not enabled, ensure that you are not merging the cell, and the cells you want to join aren’t arranged as an Excel tableAn Excel TableIn excel, tables are a range with data in rows and columns, and they expand when new data is inserted in the range in any new row or column in the table. To use a table, click on the table and select the data range.read more. Cells designed as tables regularly show exchanging shaded rows and maybe filter arrows on the column headings.

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

  • Unmerge Cells in ExcelSplit Excel CellsCombine Cells in Excel