🔗 How to Merge Cells in Excel 2021 | Step-by-Step Guide

How to merge cells in Excel 2021: Learn to merge cells in excel to give title two or more column in a single cell. Let’s explore Excel topics in this post.

How to Merge cells in Excel 2021

Here Merging cells in Excel refers to make one cell combining two or more cells into one single cell. This is often used to create titles, headings or two or more data cells in a cell or a sheet.

✅ Why Merge Cells in Excel?

• To create a heading that related to multiple columns. for example if you want to write Week day and its heading want to write Week 1, like this month name and more so you can use merge cells.

• To arrange numerical data in organized way.
• To center the title or label of two or more columns data.

🧩 Types of Merge Options in Excel 2021

To merge two or more cells in Excel go to Home Tab. Now click on Merge & Center option in Home tab, following options appeared:

1. Merge & Center – It Combines two or more cells and aligns the content in the center of the merged cell.
2. Merge Across – It Merges selected cells in each row individually. You can use shortcut (Alt+H+M+A).
3. Merge Cells – Just merges, no alignment.
4. Unmerge Cells – This command Splits merged cells back into separate cells as they was.

📝 Steps to Merge Cells in Excel 2021

👉 Example:

If you want to merge A1, B1, and C1 to create one heading. follow this process

Step-by-step Process:

1. First of all, Open Excel 2021 and Select/open your worksheet.
2. Select the cells you want to merge.
   👉 Example: Click and drag from A1 to C1.
3. Go to the Home tab on the Ribbon.
4. Click the Merge & Center button or options that you want.

✅ Your selected cells are now merged and the content is centered.

⌨️ Shortcut Key to Merge Cells in Excel 2021

There is no direct single key shortcut, but you can use:

textCopyEditAlt + H + M + C → Merge & Center  
Alt + H + M + M → Merge Cells  
Alt + H + M + A → Merge Across  
Alt + H + M + U → Unmerge Cells

👉 To use it:

• Press Alt key → then H → then M → then your option like C for Merge & Center.

⚠️ Note Before Merging:

• Only the top-left cell’s content remains after merging.
• Other data in selected cells will be deleted.

💡 Tips:

• Avoid merging in large data tables – it may affect sorting or filtering.
• Instead of merging, you can also use “Center Across Selection” from Format Cells > Alignment.

✅ Conclusion:

Merging cells in Excel 2021 is simple and helpful when creating professional-looking headers. Just remember to merge wisely — especially in data tables.

Try it now and make your Excel sheet clean and organized! 💻📊

Watch other MS Excel tutorial in Hindi

X-Lookup, Vlookup & X lookup Function Tutorial