Page 57 - TP-Play_V-2.0_Book-5
P. 57
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 centered 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
AUTOFILL
AutoFill 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 AutoFill 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.
Step 3 Position the mouse pointer over the bottom right corner of the last selected
cell. The pointer changes to (+) sign.
Step 4 Drag the mouse pointer over the cells you want to include in the series. The
cells display the number series automatically.
Editing in Excel 2016 57

