Page 38 - TP_Modular_V2.1_Class7
P. 38
To insert a column in a worksheet, follow the given steps:
Step 1 Click the column heading where you want to insert a new column.
Step 2 Click on Insert command in the Cells group under the Home tab.
Step 3 Click on Insert Sheet Columns. A new column is inserted to the left of the selected
cells and the existing columns shift rightwards.
Inserting a new column
What if you could use Excel to track the books you’ve read and the books
you want to read? How would you rate them and what genres would you
include?
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.
Merging cells
The cells will be merged in a row or column, and the cell content will be
center aligned in the merged cell.
Split Cell Merged Cells
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. 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.
36 Modular (Ver. 2.1)-VII

