Select "Insert Rows" Figure . Insert Rows popup menu Insert → Rows command is used to insert a new row. Refer Figure . Click "Insert" menu A new "Row" inserted above the selected row Select "Rows" option Figure .
Insert Rows menu bar Chapter . Open the spreadsheet which was created in Illustration . . Insert rows one by one, then insert the following student details .
Save the changes and close the file. Reg. No Name Date of Birth Tam Eng CS Eco Com Acc 12101 Sarika S 12102 Jewees Celcya J 12103 Yuvarani T 12104 Meharunisha I 12105 Priya W 12106 Vijaya Vasavi K 12107 Deepika B 12108 Viji V Self Practice: . .
Inserting Cells To insert a new cell between two existing cells, just right-click on any existing cell From the pop-up menu, select “Insert” option Figure . Insert cells The “Insert Cells” dialog box appear with four options i) Shift cells down ii) Shift cells right iii) Entire row iv) Entire Column Any one of the four options is selected. Selecting “Shift cells down”, inserts a new cell in the present location and the existing cells are shifted downwards. Selecting “Shift cells right”, inserts a new cell in the present location and the existing cells are shifted towards right.
Selecting the “Entire Row” or “Entire Column” option, inserts a new row or a new column.v Figure . Insert cells Chapter . . Inserting multiple columns or rows Multiple columns or rows can be inserted at once rather than inserting one at a time.
Select multiple rows or columns for insertion. Follow steps as in . . and .
. . . Inserting Columns, Rows and Cells using “Insert Cells” Toolbar Insert