How to Merge Cells in Microsoft Excel in 5 Ways?

The most rudimentary reason for choosing to merge cells in your Microsoft Excel book is to format and bring headings in the centre. If lately, you have been thinking about how to merge cells in Microsoft Excel, this article is your ultimate guide.

Be it making a standard report, or entering sales data, MS Excel is an inevitable part of your business and to make each of the data to be recorded look presentable you need to know the most essential ways of formatting.

Steps to Merge Cells in Microsoft Excel

This article will you through a complete course of steps which includes the steps that will help you to merge cells in MS Excel.

Step 1: Open your respective MS Excel file on which you wish to make the edits.

Step 2: Choose the cells that you wish to merge and highlight them. To select the chosen cells and mark them as chosen as per your preference, you can either choose to move your mouse over them or click the first cell and hold shift + side arrows until the preferred cell to which you want to merge.

Step 3: Go to the Home Ribbon and choose Format Cells. Alternative to this you can also choose to press the keyboard shortcut. The keyboard shortcut to choosing the Format Cells button is Ctrl+1. This will make the Format Cells dialogue box open.

Step 4: On the Format Cells select the Alignment tab. Once you have chosen the Alignment tab, immediate to that tick the box that’s labelled as Merge Cells.

Step 5: Make a click on the centre which will put the title in the centre of the respective merged cells. Choose background color so that the title is striking and stands out effectively.

At times, you might not wish to merge cells but expect the same formatting style to reflect in your excel book.

Steps to Understand Centre Across Selection Functions

Yes, if you do not want to merge cells but prefer to have the same formatting option, there is an alternative way via which you can have the same merge cells look – this option is known as the Centre Across Selection.

To understand how a Centre Across Selection functions, here are the steps involved in it:

Step 1: Open your respective MS Excel file on which you wish to make the edits.

Step 2: Choose the cells that you wish to merge and highlight them. To select the chosen cells and mark them as chosen as per your preference, you can either choose to move your mouse over them or click the first cell and hold shift + side arrows until the preferred cell to which you want to merge.

Step 3: Go to the Home Ribbon and choose Format Cells. Alternative to this you can also choose to press the keyboard shortcut. The keyboard shortcut to choosing the Format Cells button is Ctrl+1. This will make the Format Cells dialogue box open.

Step 4: Make a click on the Alignment tab and select Centre Across Selection. At this step, ensure that you have unchecked Merge Cells in case it was already checked.

Hopefully, now you would not be facing issues regarding merging cells in Excel. Microsoft Excel is one of the most crucial software that you need on daily basis for your business.

Thus, ideally, this article was helpful in its effort to assist you with how to merge cells in Excel. To know more about how to become a pro at Excel, watch out for this space for further easy tutorial articles.

---

https://www.youtube.com/watch?v=KF0NpqWtmBA

---

Frequently Asked Questions (Faqs)