Pinterest Pixel

How to Merge Cells in Excel

A great way to customize the layout of your worksheet is to Excel Online Merge Cells. You... read more

Download Excel Workbook
Bryan
Posted on

Overview

A great way to customize the layout of your worksheet is to Excel Online Merge Cells. You can merge cells together and play around with the layout to fit your purpose or reporting style.

I will also show you how easy it is to unmerge cells too!

Here is our table, you can see that the first row Sales Report is only on a single cell. Let us fix that!

How to Merge Cells in Excel

I explain how you can do this below:

How to Merge Cells in Excel | MyExcelOnline

Download excel workbookHow-to-Merge-Cells-in-Excel.xlsx

STEP 1: Make sure to select all of the cells you want to merge together:

How to Merge Cells in Excel

 

STEP 2: Go to Home > Alignment > Merge & Center

How to Merge Cells in Excel

The top row is now merged together!

How to Merge Cells in Excel

Next is let us see how easy it is to undo the merging.

 

STEP 3: Make sure to select the single merged cell that you want to unmerge:

How to Merge Cells in Excel

 

STEP 4: Go to Home > Alignment > Merge & Center > Unmerge Cells

How to Merge Cells in Excel

Now your cells are now unmerged!

See also  3 Quick Ways on How To Create A List In Excel

How to Merge Cells in Excel

How to Merge Cells in Excel

 

How to Merge Cells in Excel | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

How to Merge Cells in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!