Part – II Editing and Formatting Worksheet . Inserting Columns, Rows and Cells In Calc, Columns, rows and cells can be inserted individually or in groups. . .
Inserting a Column: When you insert a new column, it is inserted to the left of the current column. The location of the cell pointer present, is the Current column. In Calc, you can insert a new column anywhere in the worksheet. Step : Select the column where a new column should be inserted.
Step : Right-click on the selected column name that you selected. A pop-up menu appears. Step : click the “Insert Columns” option from the menu. Now, a new column will be inserted to the left of the current column.
Right Click here To insert column click Pop - up Menue appears Figure . Insert Column pop-up menu A new column can also be inserted using Insert → Columns command. (Refer Figure . ) Chapter Click "Insert" menu Select "columns" option Figure .
Insert Column menu bar . Open the spreadsheet which was created in Illustration . . Insert a new column between column E and F .
Give the heading as “Eco” and Enter the Economics marks for all the students . Insert one more column between the columns, Name and Tamil marks. . Give the heading as “Date of Birth” and Enter the date of birth for all the students.
. Save the changes and close the file. Practical Practice: . .
Inserting Rows When you insert a new row, it is inserted above the current row. The location of the cell pointer present is the current row. In Calc, you can insert a new row anywhere in the worksheet. Step : Select the row where a new row to be inserted.
Step : Right-click on the row number, a pop-up menu appears Step : click “Insert Rows” option from the menu. Now, a new row will be inserted to above the current row. Chapter Right Click here to select the row as well as get popup menu