I have been doing a lot of work in Microsoft Excel lately and there are certain basic tasks that I have never spent the time to learn or at least to remember. One of those items is merging cells together which I typically use for titles of sets of columns in the Excel documentation work that I am performing. Use the steps below to merge cells together.
Excel Workbook Example Used In This Article:
We will be using the above basic workbook in this article as the steps are easy to complete but there are a couple items you should be aware of which we will note below.
Highlight Cells You Want To Merge Together:
Notice there are four cells highlighted in the above example image. We went ahead and entered data into the cells to make the point that you will lose data in all of the cells but the top left cell you are merging together. Below we first show the location of the Merge Cells button followed by the warning you receive if you have data in the cells you are merging together followed by the final product of merged cells that now have the data that was in the top left cell spread across the merged cells in Microsoft Excel.
Merge Cells & Center Button Location:
As you can see above the Merge Cells & Center button is located in the top navigation bar under the Home tab. Now if you have data in the cells and you click the Merge Cells & Center button you will receive the below warning message.
Excel Warning Message About Data Loss In Merged Cells:
Click OK to proceed with merging the cells which will look similar to the below example.
View Of Microsoft Office Excel Cells After They Have Been Merged:
As you can see in the above steps merging cells in Microsoft Office Excel is easy as pie. Make sure you don’t lose data unexpectedly though when merging cells.