How to Merge Cells in Microsoft Excel: A Quick Guide

PDF download Download Article
Quick and easy ways to combine cells in Excel
PDF download Download Article

You can easily merge two or more cells in Microsoft Excel on Mac or Windows. Merging cells combines two or more cells into a larger cell on the sheet. If you want to merge values of cells by connecting them together into a single cell, you can create a simple formula using the CONCAT function or the "&" symbol. This wikiHow guide will teach you how to merge and combine cells in Microsoft Excel.

Things You Should Know

  • To merge two or more cells into one big cell, select the cells, then click "Merge & Center" on the toolbar.
  • Merging cells is helpful if you want one cell in your sheet to be larger, such as a cell that contains a title.
  • To merge cell values into a single cell, use the CONCAT function or the & operator.
Method 1
Method 1 of 2:

Merging Cells

PDF download Download Article
  1. To do so, click one cell, then drag your cursor to select the other cells you want to merge. The cells you merge must be touching each other. For example, you can merge A1 with B1 but not A1 with only F5.
    • Merging cells is a great way to add formatting to an Excel spreadsheet. For example, you could put “July Calendar” at the top of an Excel calendar in a larger cell without changing the width of the columns below.
    • Merging cells only retains the value of the leftmost cell and results in a larger cell on the sheet. If you want to merge two or more existing cell values into a single cell, see Merging Values .
  2. It's on the top-left side of the Excel window. This will bring up the Home toolbar.
    • You can also get to the Home tab quickly with keyboard shortcuts. Press and release the Alt key on your keyboard, then press H to access the Home tab.
    Advertisement
  3. If the cells contain values, you'll see a warning that says, "Merging cells only keeps the upper-left value and discards other values." Click OK to merge the cells. If not, the cells will merge instantly.
    • If you don't want to center the cells' content, click the ▼ icon to the right of the Merge & Center button and select a different alignment option.
    • If you pressed Alt and then H to get to the Home tab, you can press M and then C to merge and center your cells.
  4. Unmerge cells . To unmerge cells, follow these steps:
    • Select the merged cell.
    • Go to the Home tab.
    • Click the ▼ icon next to the Merge & Center button.
    • Select Unmerge Cells .
    5. Advertisement
Method 2
Method 2 of 2:

Merging Values

PDF download Download Article
  1. The CONCAT function makes it easy to concatenate the values into a single cell.
    • In this example, the contents of the two cells will appear in the new cell without a space separating them. For example, if A1 contains the word "wiki" and B1 contains "How," the new cell will be wikiHow .
    • If A1 is "John" and B1 is "Smith," the new cell will be JohnSmith .
  2. This formula will come in handy if you're combining two words that aren't supposed to butt right into each other, such as a first and last name.
    • If A1 is "wiki" and "B1" is "How," the new cell will be wiki How .
    • If A1 is "John" and B1 is "Smith," the new cell will be John Smith .
  3. You can replace and with any text you'd like. Note that there are spaces between "and" and the quote marks, which inserts spaces.
    • You can use CONCAT with more than two cells. For example, =CONCAT(A1," ",B1," ",F6," ",E6) .
  4. Another way to merge cell values is the ampersand:
    • =A1&B1 will merge the values of A1 and B1 the same way as =CONCAT(A1,B1) .
    • A1," ",B1 will combine the cell values and add a space between them, just like =CONCAT(A1," ",B1) .
    5. Advertisement

Community Q&A

Search
Add New Question
  • Question
    Can six cells be merged into two cells in Excel?
    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.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 9 Helpful 19
  • Question
    How do I activate the merge cells option when it's grayed out?
    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.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 31 Helpful 10
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Read Video Transcript

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      Advertisement

      You Might Also Like

      How to
      Group and Outline Excel Data: Easily Collapse Rows of Info
      How to
      Apply Conditional Formatting in Excel
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      How to
      Type Formulas in Microsoft Excel
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      Advertisement

      About This Article

      Article Summary X

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

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 758,932 times.

      Is this article up to date?

      Advertisement