
Method 1
To merge cells using the Merge and Center tool on the ribbon, here's how:
Step 1: Select the cell range you want to merge.



To merge cells using the controls in the Alignment tab of the Format Cells dialog box, here's how:
Step 1: Select the cell range you want to merge.
Step 2: Right-click on the selected cells, and click on Format Cells.


You can merge cells in Excel by simply pressing shortcut key: Alt+Enter.
When merging cells and more than one of the selected cells contains data, the data in the upper-left or upper-right cells is kept and all remaining data is deleted.
When it prompts this warning dialog. Click on OK to confirm merge cells.

0 comments:
Post a Comment