Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to align text across cells with merge in Excel

How to align text across cells with merge in Excel

Transcript 

In this lesson we'll look at how to align text across multiple columns or rows by merging cells.

Let's take a look.

Here we have a simple table meant to summarize the features of a hypothetical service plan.

One thing you might want to do with a table like this is combine cells with like values. For example, Feature Y is not offered in Plans A, B, or C, and feature Z is not applicable to Plan A or B. So, we could combine these cells to visually simplify the layout.

In a case like this, you can easily merge cells. The Alignment group on the home tab of the ribbon provides three merge options: Merge & Center, Merge Across, and Merge Cells.

Before we try these on our main table, let's look at what each command does.

Merge Cells combines all selected cells into one cell. If the cells contain text, only the value in the upper left cell will survive the merge. Merge & Center does the same thing as Merge Cells, but it also centers the text horizontally.

The Merge Across command joins cells across columns, but not rows. If the cells contain text, only the value in the leftmost cell will be maintained. You can select more than one row, but each row is processed separately.

With each of these options, the resulting cells will display Merged on the Alignment tab in the Format Cells dialog box. Unchecking Merge will bring back all cells but without the original content or borders.

The Unmerge Cells command on the ribbon does the same thing.

With all of that in mind. Let's look at our table. We can see that Merge & Center is a good option for both rows 11 and 12.

We can also use Merge & Center to center the table header across the entire table.  

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
I just want you to know that ExcelJet has quite honestly changed my life...I now have my own business as a bookkeeper. Bookkeeping requires Excel on a DAILY basis to manipulate data & get it in and out of QuickBooks. I use conditional formatting, INDEXMATCH, VLOOKUP, IFS, everything I have learned from ExcelJet. The 2-3 minute courses are a dream ..... I could open up 5 and watch them and come back later. Plus you are all super organized & clear in how you teach Excel. Watching videos on YouTube piecemeal from many different instructors never worked for me. ExcelJet was the real deal!!
Ainsley
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page