Editing and Formatting Worksheet · Part 2

a new row. Refer Figure . . Click "Insert" menu A new "Row" inserted above the selected row Select "Rows" option Figure . Insert Rows menu bar . Open the worksheet 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 Workshop . . 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 can be 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 respectively. Figure . Insert cells . . 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 Cells floating toolbar is also used to insert cells, rows and columns Click View → Toolbars → Insert Cell A floating toolbar appears on the screen with four icons.