Page 51 - TechPluse_C6_Flipbook
P. 51

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.
                                                                                          Selecting a row
                 Step 3    Hover mouse pointer over the Insert Rows option. 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.
                                                                                      Selecting a column
                 Step 4    Select the Columns Before or Columns
                           After option. A new column is inserted to the left or right of the selected cells and the
                           existing columns shift rightwards or leftwards.











                                      Selecting a row                                    Selecting a row

                     MERGING CELLS

                 Calc allows you to merge multiple cells to make a single cell. Perform the following steps to
                 merge the selected cells:


                                                                                      More on LibreOffice Calc       49
   46   47   48   49   50   51   52   53   54   55   56