Merging Data

In our earlier merge example, we selected several adjacent cells that were blank, empty of data. What happens if you merge together several cells that have data?

 

Before You Begin: Enter sample data

In Cell C3 type: Bananas

In Cell D3 type: Apples

 

3. Try This: Merge Data

Select: Cell C3 and D3.

Go to Home-> Alignment.

Click on Merge and Center.

 

What Do You See? If several cells have data, Microsoft Excel will only keep the information from the first cell.

 

Please close this spreadsheet. You do not have to save it.

 

Memo to Self: The first cell is defined as the upper-left most cell in the spreadsheet.

Home-> Alignment ->Merge and Center

  

 

 

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.2. Merge or split cells: Merge Across