Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 36 - 2629_Devagiri_C-6
P. 36

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

                                                  2    Click on the Insert down arrow.

                                                                                     3    Select the Insert
                                                                                     Sheet Rows option.

                                 1    Select the row above which
                                 you want to insert a new row.
                      A new row will be inserted above the selected row.
                      Similarly, you can insert a column by selecting a column and choosing the Insert Sheet Columns

                      option. The new column will be inserted to the left of the selected column.

                       RAPID RECALL                             Tick ( ) if you know this.

                          1.  You can easily add, rename or delete worksheets to organise your data better.
                          2.  You can relocate a worksheet to a different position within the same workbook

                              or transfer it to another workbook.

                             DELETING CELLS, ROWS AND COLUMNS

                      In Excel, you  can  quickly  delete  cells, rows or columns  to
                      clear unwanted data and maintain a clean, well-organised                           QR QUEST
                      worksheet.
                                                                                                      Visit the given link

                      DELETING CELLS                                                       to learn how to insert or delete
                                                                                                 rows and columns:
                      You  can delete  a cell or a range of cells in Excel and the              https://www.youtube.com/
                      surrounding data will shift accordingly to fill the space.                 watch?v=JvSoAAkcWyY
                                                                                           Answer the given questions:
                                              SHORT SIGN                                   1.   What are the key takeaways
                                                                                             from the given video?
                                                                                           2.   Describe what happens when
                                             To delete a row or
                                              column: Ctrl + -                               you delete a row in Excel.

                       34
                            Premium Edition-VI

| 31 32 33 34 35 36 37 38 39 40 41 |