Page 231 - IT_Play_V1.0 Class9
P. 231

Cutting/Copying the Contents
                 The contents of a cell or a range of cells can be cut or copied from one place to another. Following are the
                 steps to do so:

                 Step 1:  Select the cell or range of cells that is to be cut or copied.
                 Step 2:  Click on the Edit menu from Menu bar.

                 Step 3.  Select the Cut or Copy option from the drop-down menu. OR Click on the Cut or Copy icon from
                         the Standard toolbar.
                 To paste the contents at another position:

                 Step 1:  Click on the cell where it has to be pasted.

                 Step 2:  Click on the Edit menu from Menu bar.
                 Step 3.  Select the Paste option from the drop-down menu. OR Click on the Paste icon from the Standard
                         toolbar.
                 The selected content gets pasted at the new location.

                 Inserting Rows and Columns

                 To insert a new row in a sheet, follow the given steps:
                 Step 1:  Select the row where you want to insert a new row above or below.

                 Step 2:  Click on Sheet menu from Menu bar.

                 Step 3:  Select Insert Rows option from the drop-down menu. Select the desired option from the sub-menu.
                 Step 4:  Select Rows Above to add rows above the selected row.

                         The new row will appear on the screen.

                                                                                 2


                    3                                                            4






                    1




                 To insert a new column in a sheet, follow the given steps:
                 Step 1:   Select the column where you want to insert a new column before or after.

                 Step 2:  Click on Sheet menu from Menu bar.
                 Step 3:  Select  Insert Columns option from the drop-down  menu. Select the desired option from the
                         sub menu.
                 Step 4:  Select Columns Before to add columns to the left of the selected column.

                         The new column will appear on the screen.







                                                                     Applying Formula and Functions in Spreadsheet  229
   226   227   228   229   230   231   232   233   234   235   236