Page 47 - Touchpad_Plus_V3.2_Class 6
P. 47

INSERTING ROWS/COLUMNS

                 LibreOffice  Calc  allows  you  to  insert  rows  and  columns  in  a  worksheet  according  to  your
                 requirement.
                 Inserting Rows

                 To insert a row in a worksheet, follow these steps:

                 Step 1  Click and select the row heading where you want to
                          insert a new row.
                 Step 2  Click on the Sheet menu.

                 Step 3  Hover mouse pointer over the Insert Rows option.
                                                                                             Selecting a row
                          A submenu appears.
                 Step 4  Select  the  Rows  Above or  Rows  Below  option.  A  new  row  is  inserted  above  or
                          below the selected row and the existing rows shift downwards or upwards as the case
                          may be.















                                    Inserting a new row                                  New row inserted
                 Inserting Columns


                 To insert a column in a worksheet, follow these steps:
                 Step 1  Click and select the column heading where you want
                          to insert a new column.

                 Step 2  Click on the Sheet menu.

                 Step 3  Hover mouse pointer over Insert Columns option. A
                          submenu appears.
                 Step 4  Select the Columns Before or Columns After option.                 Selecting a column
                          A  new  column  is  inserted  to  the  left  or  right  of  the  selected  cells  and  the  existing
                          columns shift rightwards or leftwards.











                                    Selecting a column                                 New column inserted





                                                                                      More on LibreOffice Calc       45
   42   43   44   45   46   47   48   49   50   51   52