EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Merge and Center
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Merge and Center

By Ashwani JaiswalAshwani Jaiswal

Merge and Center in Excel

Excel Merge and Center (Table of Contents)

  • Merge and Center in Excel
  • How to use Merge and Center?
  • Pros and Cons of Merge and Center in Excel

Merge and Center in Excel

Merge and Center commands in Excel are available in the Home menu ribbon’s Alignment section, which merges or combines two cells into one and aligns them at the center. First, to merge any two cells, select the two cells minimum, which is located adjacent to each other, and then Click on Merge and Center. It will merge those selected cells but keeping the value of only the first cell. We can use Merge, Merge Across also from the drop-down list of Merge and Center.

How to use Merge and Center in Excel?

We use Merge and Center in Excel to merge a group of cells or to center the headings or text. Merge, and Center is located in the Home menu tab under the Alignment section. Using Merge and Center in Excel is very easy and convenient.

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

Let’s understand how to Merge and Center in Excel with some examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

Merge and Center in Excel – Example #1

We have sales data for products of a month below. And we have named this table as Sales and Order, which is on the top row in font size 20, just to have pure clarity and visibility of the performed function.

Merge and Center example 1-1

Now to merge the table name Sales and Order in one cell so that it will become the table’s heading, select cells that you want to be merged in with Sales and Order text as shown below.

Merge and Center example 1-2

Now go to Home, and click on Merge and Center in the Alignment section.

Merge and Center example 1-3

As we click on Merge and Center, we will see the text Sales and Order is now merged in a single cell. You can later change the alignment of merged text to any position as per your need.

Merge and Center example 1-4

You can unmerge the cells as well if you want to. For that, follow the same path and click on the down arrow available in the right corner of the Merge and Center option. We will have more options, and one of them is Unmerge Cells.

Merge and Center example 1-5

Click on it. It will unmerge the cell, and the text will come back to the same previous format.

Merge and Center in Excel – Example #2

We will see another function of Merge and Center in Excel, which is Merge Across. Unlike Merge and Center in Excel, Merge Across is used to merge multiple rows or multiple line items. Where in Merge and Center, we could only merge one cell with multiple cells.

In Merge Across, a text comes to one side of the selected cells or row.

Below, we have some numbers in different rows. Here, we will merge them together in one row.

Merge and Center example 2-1

Select all cells covered in the box. Select Merge Across from a drop-down list of Merge & Center. Once we click on it, we will get the complete selected multiple rows merged with numbers entered from row 2 to 6 as below.

Merge and Center example 2-2

If we need to unmerge the merged cells, then select the Unmerge Cells options from the drop-down, as shown below.

Merge and Center example 2-3

Once we click on Unmerge Cells, the whole row will come back to the same condition as these were before.

Merge and Center example 2-4

Merge and Center in Excel – Example #3

We can directly merge any cell content with multiple cells. This is an easy and quick process to perform. For that, we have sample data below.

Merge and Center example 3-1

In the above screenshot, we have some numbers from 1 to 5 in sequence. Now Let’s try to merge any of the numbers with one or more than one cell. First, select the range of those cells that we need to merge together, as shown below.

Range of cells

Above, we have selected the cell from B2 to D2 in a range. Now select Merge Cells from the drop-down list of Merge & Center, as shown in the below screenshot.

Merge Cells from drop-down

Once we click on it, the selected cells will get merged as one single cell. And the data present in the first cell will be the only cell data carried in other merged cells, as shown in the below screenshot.

Merged Cell 1

Let’s see what happens when we merge the cell number B5 and B6, as selected in the below screenshot.

Merged Cell 2

Now select Merge Cells from a drop-down list of Merge & Center. Once we do that, we will get a warning message, as shown below. This means only the upper or first value will be kept, and the rest will be discarded. Then, to proceed further, click on OK as shown below.

Example

Once we do that, the selected cells will get merged with only one value: the first or upper value from the range, as shown below.

Merge Cell

If I want to see the value in the previous format, then unmerge the cells by selecting Unmerge Cells option from a drop-down list of Merge & Center as shown below.

Unmerge Cells

After that, all the merged cells will get separated, and only the upper or first value will be retained further, as shown below, losing the rest of the value.

Upper or First Value

Pros

  • It manages data to look good by having a single value for multiple headers.
  • By changing the position of merged cells, we can adjust the data and its visibility as per requirement.
  • Merge & Center can be used for both rows and columns.

Cons

  • Not advised to use where any file has a huge amount of data, and it is becoming bulky to handle it.

Things to Remember

  • Always change the alignment of the merged cell so that it would help in adjusting and looking for correct attributes.
  • Use Wrap Text, which is located above Merge & Center, so that if a cell has lengthy text, then by wrapping, it will be visible in the same cell and will be in its border.
  • If all the selected cells are having data, then only the first or upper cell value will be carried and merged.

Recommended Articles

This has been a guide to Merge and Center in Excel. Here we discussed How to use Merge and Center in Excel and also unmerge the cells, Pros, and cons of Merge and Center in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Merge Cells in Excel
  2. Excel Merge Two Tables
  3. Excel Unmerge Cells
  4. Excel Shortcut For Merge Cells
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Merge and Center Excel Template

EDUCBA

Download Merge and Center Excel Template

EDUCBA

डाउनलोड Merge and Center Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more