Page 55 - TP_Play_V2.1_class5
P. 55

Clickipedia



                   At times, a cell might display #####. This can occur when the cell contains a
                   number or a date that exceeds the width of the cell so it cannot display all the
                   characters that its format requires. To see the entire contents of  the cell with its
                   current format, you must increase the width of the column.

                    INSERTING ROWS/COLUMNS


                 To insert a row in a worksheet, follow the given steps:
                 Step 1:  Click the row heading where you want to insert a new row.

                 Step 2:  Click on Insert command in the Cells group under the Home tab.

                 Step 3:  Select the Insert Sheet Rows option from the drop-down list. A new row is

                          inserted above the selected row and the existing rows shift downwards.

                                                                                     2     3







                                       1


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


                 Step 1:  Click the column heading where you want to insert a new column.

                 Step 2:  Click on Insert command in the Cells group under the Home tab.

                 Step 3:  Click on Insert Sheet Columns. A new column is inserted to the left of
                          the selected cells and the existing columns shift rightwards.

                                                                                     2





                                        1
                                                                                        3



                                                         Inserting a new column



                                   What if you could use Excel to track the books you’ve read and the books
                                   you want to read? How would you rate them and what genres would you
                                   include?



                                                                                        Editing in Excel 2016     53
   50   51   52   53   54   55   56   57   58   59   60