Page 73 - TP_iPlus_V2.1_Class7
P. 73
i + INSERTING ROWS/COLUMNS
Let us now learn about inserting rows and columns in a worksheet.
Inserting Rows
To insert a row in a worksheet, follow the given steps:
2 Click on the 3 Click on the
Home tab. Insert command
on the Cells group.
1 Click on the row 4 Click on the
heading where you
Insert Sheet Rows
want to insert a
option from the
new row.
drop-down list.
A new row is inserted above the selected row, and the existing row shift downwards.
Inserting Columns
To insert a column in a worksheet, follow the given steps:
3 Click on the Insert command on the Cells group.
2 Click on the
Home tab.
4 Click on the
1 Click on the column Insert Sheet
heading where you want
Columns
to insert a new column.
option from the
drop-down list.
A new column is inserted to the left of the selected cells, and the existing column shift
rightwards.
71
More on Spreadsheets

