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.
Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Online. Utilize import, export, and delete services of Dancing Numbers software.
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.
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.
Frequently Asked Questions (Faqs)
Once I have Merged Cells in Excel, How can I Unmerge the Same Cells?
Once you have chosen to merge cells in Excel, with very easy and simple steps you can make the action reverse and unmerge the cells. To unmerge the merged cells, there are two ways. The first way to unmerge the merged cells is by using a shortcut key.
One after the other, press these keys ALT + H + M + C. Once you have performed this action, the merged cells would be unmerged immediately.
If you wish to unmerge the merged cells via steps, follow the same as being specified below:
Open your respective MS Excel file. Choose the cells that you wish to unmerge. Tap on Home. Under Alignment group, tap on the Merge & Center icon.
How can I Unmerge Cells more Quickly with Quick Access Toolbar?
If you wish to unmerge cells more quickly with Quick Access Toolbar, follow the same as being specified below:
Tap on the Home Tab. Under Alignment group, select the Merge & Center icon. Choose to make a click on the Add to Quick Access Toolbar.
With these steps, you would be adding the Merge & Center icon to the Add to Quick Access Toolbar. When you wish to unmerge the cells, just make respective selection cells and click on the Add to Quick Access Toolbar.
What are Keyboard Shortcuts Related to Merging and Unmerging of Cells in MS Excel?
The respective keyboard shortcuts related to merging and unmerging of cells in MS Excel are:
Merge Cells: ALT H+M+M Merge & Center: ALT H+M+C Merge Across: ALT H+M+A Unmerge Cells: ALT H+M+U
+1-800-596-0806