Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
Excel has a unique button which is merge and center which is used to merge two or more different cells, when data is inserted to any merged cells it is in the center position thus the name as merge and center, re-clicking on the button unmerge the cells but the value in the cell merged is located to the initial first cell in the worksheet.
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. This is finished by choosing all cells to be merged and picking the “Merge Cells” order. Center means that it enables the alignment of text to be in the center.
How to Use Merge and Center in Excel?
1. Select the adjacent cells you want a merge.
2. On the Home button, go to alignment group, click on merge and center cells in excel.
3. Click on merge and center cell in excel to combine the data into one cell.
4. Once you click, merge and Centre, selected cells will be 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 shortcut.
#2. Press the Alt key that enables the commands on the Excel ribbon.
#3. Press H to select the Home tab in the Excel ribbon, it enables the Home tab of Excel.
#4. Press M (shortcut) to enable the Merge & Center option in excel.
#5. Press any one of the following 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 separately 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 combine the selected cells in each row individually.
- Merge Cells: This option joins the selected cells into a single cell without centering the text in the cell.
- Merge and Center: This option enables to merge the cell and align the text into the center.
Things to Remember
- If you are using any formulas by using the cell which was merged, make sure to unmerge the cell before using any formula.
- While merging any cell make sure to check the right and left side data in a cell because once you merge the cell it automatically deletes the data from the adjacent cell.
- The cell cannot be merged separately like if you are merging cell A1 to D1 it will be called cell A1 after merge and center.
- To change the text alignment after merging the cell, essentially select the merged cell and tap the ideal alignment in the Alignment group on the Home tab
- After clicking Ok, click on find all and it will give you a result at which column cell are merged.
- To change the content arrangement after the text was merged, just select the merged cell and tap the desired arrangement in the Alignment group on the Home tab.
- Make sure that the information you need to excel cell merge and center is in the upper-left cell, and remember that all information in the other merged cells will be erased. To hold any information from those different cells, copy it to somewhere else in the worksheet before you merge the cells.
- Select the as many rows as you want, however not more than the one column. Likewise, make sure that are adequate void segments to one side, so none of your information is erased. Just include empty rows, if it is important to be added.
- If any chance Merge and Center is not enabled, ensure that you’re not merging the cell and the cells you want to merge aren’t arranged as an Excel table. Cells designed as a table regularly show exchanging shaded rows, and maybe filter arrows on the column headings.
This has been a guide to Merge and Center in Excel and its shortcut. Here we discuss how to merge and center in excel using the menu and excel shortcut along with practical examples and downloadable excel templates. You may also look at these useful functions in excel –