How to Merge Cells in Excel

This wikiHow teaches you how to merge two or more cells in Excel. You can do this on both Windows and Mac versions of Excel.

Steps

  1. Image titled Merge Cells in Excel Step 1
    1
    Open your Excel spreadsheet. Double-click an Excel document to open it in Excel.
    • If you haven't yet created the document, open the Excel program and click Blank Workbook.
  2. Image titled Merge Cells in Excel Step 2
    2
    Select the cells you want to merge. Click one cell, then drag your mouse to select the other cell(s) you want to merge.
    • For example, if you want to merge cells A1 through C1, you would click and drag from A1 right to C1.
    • The cells you merge must be touching each other; for example, you can merge A1 with B1, but not with C1 without merging B1 as well.
    Advertisement
  3. Image titled Merge Cells in Excel Step 3
    3
    Click the Home tab. It's in the top-left side of the Excel window. This will bring up the Home toolbar below the green ribbon at the top of the Excel window.
  4. Image titled Merge Cells in Excel Step 4
    4
    Click Merge & Center. This box is in the "Alignment" section of options in the Home toolbar. Doing so will automatically merge your selected cells and center their content.
    • If you don't want to center the cells' content, click instead the ▼ icon to the right of Merge & Center and then click Merge Cells.
    Advertisement

Community Q&A

  • Question
    Can six cells be merged into two cells in Excel?
    GaiusG
    GaiusG
    Community Answer
    Yes, of course that's possible. Choose 3 cells to be merged into a single cell, then repeat the process with the remaining three cells.
  • Question
    How do I activate the merge cells option when it's grayed out?
    Community Answer
    Community Answer
    Try highlighting the cells that are to be merged first; the option may be grayed out because there is nothing to merge available.

Warnings

Advertisement

You Might Also Like

Group and Outline Excel Data
How to
Group and Outline Excel Data
Apply Conditional Formatting in Excel
How to
Apply Conditional Formatting in Excel
Add Two Cells Containing the Sum of Other Formulas in Excel
How to
Add Two Cells Containing the Sum of Other Formulas in Excel
Type Formulas in Microsoft Excel
How to
Type Formulas in Microsoft Excel
How to
Unhide Rows in Excel
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Open a Password Protected Excel File
How to
Open a Password Protected Excel File
Convert Notepad to Excel
How to
Convert Notepad to Excel
Download Microsoft Excel
How to
Download Microsoft Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Advertisement

About This Article

JL
Written by:
Jack Lloyd
Tech Specialist
This article was written by Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 325,455 times.
How helpful is this?
Co-authors: 7
Updated: May 5, 2021
Views: 325,455
Categories: Microsoft Excel
Article SummaryX

1. Open the Excel document.
2. Select cells to merge.
3. Click Home.
4. Click Merge & Center.

Did this summary help you?
Advertisement