A great way to customize the layout of your Excel worksheet is to merge multiple cells into one cell.  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!

merge cells in Excel

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

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

merge cells in Excel

 

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

merge cells in Excel

The top row is now merged together!

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:

merge cells in Excel

 

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

merge cells in Excel

Now your cells are now unmerged!

merge cells in Excel

How to Merge Cells in Excel

merge cells in Excel

HELPFUL RESOURCE:

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+