Question

9. What do you mean by splitting of cells? Write the steps to split a cell.​

Answer 1

Explanation:

Split cells

Click in a cell, or select multiple cells that you want to split.

Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.

Enter the number of columns or rows that you want to split the selected cells into

Answer 2

Answer:

Explanation:

Combining multiple cells (two or more) that are in the same row and/or in the same column to a single cell is known as merging cells. Separating the cells that are merged is known as splitting cells.

Steps to merge cells – First method:

• Select the cells you want to merge (row wise or column wise).

• Go to Home menu in excel.

• Click on Merge & Center.

• Click on Merge Cells.

Steps to merge cells – Second method:

• Select the cells you want to merge (row wise or column wise).

• Right click on the mouse.

• Click on Format Cells.

• Click Alignment tab.

• Check Merge cells text box.

• Click OK.

Steps to split cells:

• Select merged cells you want to split.

• Click Home menu in excel.

• Click Merge & Center.

• The merged cells moves to the left hand side when cells are split.