Page 73 - TP_iPlus_V2.1_Class7
P. 73

i +  INSERTING ROWS/COLUMNS

                 Let us now learn about inserting rows and columns in a worksheet.
                 Inserting Rows

                 To insert a row in a worksheet, follow the given steps:


                        2  Click on the                                                         3  Click on the
                       Home tab.                                                               Insert command
                                                                                               on the Cells group.

                   1  Click on the row                                                          4  Click on the
                  heading where you
                                                                                                Insert Sheet Rows
                  want to insert a
                                                                                                option from the
                  new row.
                                                                                                drop-down list.

                 A new row is inserted above the selected row, and the existing row shift downwards.












                 Inserting Columns

                 To insert a column in a worksheet, follow the given steps:


                                                  3  Click on the Insert command on the Cells group.
                            2  Click on the
                           Home tab.

                                                                                                    4  Click on the
                   1  Click on the column                                                           Insert Sheet
                  heading where you want
                                                                                                    Columns
                  to insert a new column.
                                                                                                    option from the
                                                                                                    drop-down list.


                 A new column is inserted to the left of the selected cells, and the existing column shift
                 rightwards.



















                                                                                                                  71
                                                                                          More on Spreadsheets
   68   69   70   71   72   73   74   75   76   77   78