Page 35 - TP_Prime_v2.2_Class_6
P. 35
Splitting Cells
Splitting cells means to separate two cells that were previously merged. To split merged
cells, follow these 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 on
Home tab.
Step 3: Select the Unmerge Cells option. MORE ON EXCEL
33
Splitting Cells
The cells will split and the contents of the merged cell will appear in the upper-left cell of
the range of split cells.
Formatting Spreadsheets
To further enhance your spreadsheet, you can format a number of elements such as text,
numbers, cell styles, and table styles.
Wrap Text
You can display multiple lines of text inside
a cell using Wrap Text feature. Wrapping
text in a cell does not affect other cells.
To do so, follow these steps:
Step 1: Click on the cell in which you want
to wrap the text.
Step 2: Click on the Wrap Text command
from Alignment group under Home Text before Wrapping
tab.

