What is Merge and Centre ?
Merge & Center is a feature in excel that combines multiple cells and centers the contents of the first cell. You can merge columns and rows too. This is used to combine multiple cells into a single cell and create the main headers for Excel dashboards in Microsoft Excel.
There are four options available in Merge and Center:-
2nd Merge Across : This feature works only on the selected rows and combines the multple columns of the row
but the text in the merged cell will be right aligned.
3rd Merge Cells : This feature just combines the selected cells
4th Unmerge Cells : This feature Unmerge the selected cells to their default place
Note: Merge and Centre option takes the text of only one cell which will be upper-left most cell while performing Merge and center.
You have to be careful about your content in the cells which is to be merged. So let’s get this by an example below.
So we will use the F4 key to perform the last function again.
How to Unmerge Cells in Excel
So when you have two or cell merged and you want to unmerge them, use merge and center button.
Select merged Cells
And It’s done. The cells are unmerged.
Now remember that the value that was in the merged cell will be only in the left-upper cell and the other cell will be empty, blank, null, void and black hole as you can see in the below image.
I found some frequently asked questions related to Merge and Center in Excel.
Hope this article about using Merge and Center in Microsoft Excel is explanatory. Find more articles on using more keyboard shortcuts here. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
Related Articles :
How to use the Shortcut To Toggle Between Absolute and Relative References in Excel : F4 shortcut to convert absolute to relative reference and same shortcut use for vice versa in Excel.
How to use Shortcut Keys for Merge and Center in Excel : Use Alt and then follow h, m and c to Merge and centre cells in Excel.
How to Select Entire Column and Row Using Keyboard Shortcuts in Excel : Use Ctrl + Space to select whole column and Shift + Space to select whole row using keyboard shortcut in Excel
Paste Special Shortcut in Mac and Windows : In windows, the keyboard shortcut for paste special is Ctrl + Alt + V. Whereas in Mac, use Ctrl + COMMAND + V key combination to open the paste special dialog in Excel.
How to Insert Row Shortcut in Excel : Use Ctrl + Shift + = to open the Insert dialog box where you can insert row, column or cells in Excel.
50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.
Popular Articles :
How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.
How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
How to Use SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.
How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don’t need to filter your data to count specific values. Countif function is essential to prepare your dashboard.