Menu Monday - Merge & Center (Merge Cells)

When putting together a dashboard or a report, a function that can be very useful is the "Merge & Center" function.   Merge & Center will combine two or more adjacent cells to create one larger cell.  A great example of using this function is when you have a header that spans across multiple columns.

This function is useful when you want to merge the adjacent cells as well as center the text in them

-To use this function:

-Select the adjacent cells that you want merged together

-Note: The cells can be any combination of adjacent cells in the same row, adjacent cells in the same column, or adjacent cells in rows and columns

-Click on the Home tab

-Click on the Merge & Center icon in the Alignment section

-Click on Merge & Center

-Now you will see your text merged into one larger cell and centered

-Example 1

-In this scenario, I want to create a header in row 3 called "Fruit" that spans across columns B-G

-Select cells B3-G3

-Click on the Home tab

-Click on the Merge & Center icon in the Alignment section

-Click on Merge & Center

-Now you will see "Fruit" centered across cells B3-G3

-When you click in the cell it will now be one large cell

 

Excel ya later!