Editing and Formatting Worksheet

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 to be inserted. Step : Right-click on the selected column name. 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 Menu appears Figure . Insert Column pop-up menu A new column can also be inserted using Insert → Columns command. (Refer Figure . ). Click "Insert" menu Select "Columns" option Figure . Insert Column menu bar . Open the worksheet 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. Workshop . . 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. Right Click here to select the row as well as get popup menu Select "Insert Rows" Figure . Insert Rows popup menu Insert → Rows command is used to insert