• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Merge and Center in Excel

April 20, 2021 by Andrew Childress
Merge Cells in Excel

Spreading a single cell spread across multiple cells is a technique that helps with readability. Here's how to merge and centering in Excel.

Sometimes, you may want to have the contents of a single cell spread across multiple cells in a spreadsheet. This technique helps with readability, and it’s called merging and centering. Let’s learn how to merge and center in Microsoft Excel.

How to Merge and Center in Excel (Across Columns)

Excel offers multiple ways to merge and center cells. The easiest is used when you want to merge the contents of one cell across multiple cells in the same row. For example, look at cell B1 below. Imagine that you want to merge across cells C1 and D1 as well.

Merge center Excel

To get started, click into the cell containing the data that you want to merge across the other cells. Here, that’s cell B1. Then, with your cell still selected, click and drag to highlight cells C1 and D1. This tells Excel exactly where and how to merge your data.

Merge and center in Excel

Finally, on the Home tab on the ribbon, click Merge & Center. Watch as the three cells merge. You’ll notice that cell B1 expands to fill the space formerly occupied by C1 and D1. Plus, your text will jump into position in the center of the merged cell.

Merge cells in Excel

How to Merge and Center in Excel (Across Columns and Rows)

Excel also lets you merge and center vertically. Using the above example, imagine that you want the text centered across the range B1:D2.

Repeat the earlier steps of clicking on the data-containing cell, then select the surrounding cells that you want to center across. Click Merge & Center once again, and you’ll see cell B1 expand across all six of the highlighted cells.

Merge and center in Microsoft Excel

Notice that the text centers, but appears at the bottom of the cell. This is the default alignment, but you can quickly change it. With the cell selected, click Middle Align on the Home tab. The text will jump to the middle of the cell, vertically and horizontally centered.

How to merge and center Excel

As you can see, it’s easy to merge and center inside Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Countifs Function ExcelCOUNTIF Function in Excel
Next Post:Drop-down List in ExcelDropdown list Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top