Microsoft Office Tutorials and References
In Depth Information
Merging and unmerging cells
SET UP You need the DataLabels workbook located in the Chapter01 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
1
Select cells B2:D2 .
2
Click the Home tab, click the Merge & Center arrow, and then click Merge Cells to
merge the cells into a single cell.
3
Select cells B3:F3 .
4
Click the Home tab, click the Merge & Center arrow, and then click Merge & Center
to merge the cells into a single cell and center its contents.
5
Select cells B5:E8 .
6
Click the Home tab, click the Merge & Center arrow, and then click Merge Across to
merge the cells in each row into a single cell. The operation creates four merged cells.
7
Select cell B2 .
8
Click the Home tab, click the Merge & Center arrow, and then click Unmerge Cells to
split the merged cell into its original cells.
9
Select cells B2:D2 .
10
Click the Home tab, click the Merge & Center arrow, and then click Merge & Center
to merge the cells into a single cell and center its contents.
CLEAN UP Close the DataLabels workbook, saving your changes if you want to.
Search JabSto ::




Custom Search