/>
X
Innovation
Why you can trust ZDNET : ZDNET independently tests and researches products to bring you our best recommendations and advice. When you buy through our links, we may earn a commission. Our process

'ZDNET Recommends': What exactly does it mean?

ZDNET's recommendations are based on many hours of testing, research, and comparison shopping. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing.

When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. Neither ZDNET nor the author are compensated for these independent reviews. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers.

ZDNET's editorial team writes on behalf of you, our reader. Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. Our editors thoroughly review and fact-check every article to ensure that our content meets the highest standards. If we have made an error or published misleading information, we will correct or clarify the article. If you see inaccuracies in our content, please report the mistake via this form.

Close

How to merge cells in Excel

Merging or combining cells into one can be useful when formatting a table. In this how-to guide, we'll take you through the process step by step
maria-diaz
Written by Maria Diaz, Staff Writer on

Merging cells is one of Excel's basic features in formatting spreadsheets, available in vertical and horizontal patterns. A merged cell at the top of a table can work as a header, or it can delineate a category. 

If you've ever wondered how to merge cells, we'll walk you through the process:

How to merge cells in Excel

How to merge cells in Excel
Image: Maria Diaz / ZDNet

Step 1: Select the cells to merge into one

Select which cells to merge

The first cell you select should contain the information you want on your merged cell

Image: Maria Diaz / ZDNet

Keep in mind that the information on the first cell to be selected is what will go on the combined cell, so the contents of any other selected cell will be deleted once you merge cells. 

Step 2: In the Home tab, click on Merge & Center

Click on Merge & Center and cells will be merged
Image: Maria Diaz / ZDNet

Cells will be merged into one, occupying the real estate of the other cells you had selected. This can be done in columns vertically by repeating the same process.

FAQs

How do I unmerge cells?

Click on the merged cell to select it, and go to the same Merge & Center button. Clicking this button will separate the merged cells automatically, though there is a dropdown menu to the right of it that will give you the option to Unmerge Cells.

How can I combine full columns or rows?

You can merge columns or rows together by selecting them and clicking on Merge & Center in the Home tab on Excel. 


Editorial standards

Related

How to get Microsoft Office for free
zd-microsoft-office.jpg

How to get Microsoft Office for free

Make your PDFs safer and easier to edit with over 70% off this editing tool
replace-this-image.jpg

Make your PDFs safer and easier to edit with over 70% off this editing tool

Convert documents to and from PDFs for a lifetime for only $30
replace-this-image.jpg

Convert documents to and from PDFs for a lifetime for only $30