Page 56 - TP_Play_V2.1_class5
P. 56
MERGING CELLS
To merge cells, follow the given steps:
Step 1: Select two or more adjacent cells that you want to merge.
Step 2: Click on Merge & Center command in the Alignment group on Home
tab.
2
1
Merging cells
The cells will be merged in a row or column, and the cell content
will be center aligned in the merged cell.
Merged Cells
Split Cell
To split a cell, follow the given steps:
Step 1: Select the merged cell you want to split.
Step 2: Click on the arrow of the Merge & Center command in the Alignment
group under Home tab.
Step 3: Select the Unmerge Cells option. The cells will split and the contents of
the merged cell will appear in the upper-left cell of the range of split cells.
2
3
1
Splitting cells
AUTO FILL
Auto Fill feature automatically fills a series of data in your worksheet. It saves your
time to complete the text or number series for you. To use Auto Fill feature, follow
the given steps:
Step 1: Enter the first two numbers you want to start the series with.
Step 2: Select both the cells containing the numbers you have entered.
54 Play (Ver. 2.1)-V

