Page 25 - Plus_V2.2_C6_Flipbook
P. 25

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 these steps:

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

                 Step 2:  Click on Insert command under the Cells group on the Home tab.
                 Step 3:  Select the Insert Sheet Rows option from the drop-down list.



















                                                          Inserting a new row
                 A new row will be inserted above the selected row.

                 To insert a column in a worksheet, follow these steps:

                 Step 1:  Click the column heading where you want to insert a new column.
                 Step 2:  Click on Insert command on the Home tab.

                 Step 3:  Click on Insert Sheet Columns.
                                                                                                 Inserting a new column
                 A new column will be inserted to the left of the selected column.

                        MERGING CELLS


                 While working on Excel you might need
                 to combine some cells to show a part of
                 data under one heading. Combining two
                                                                      Merged Cells
                 or more  cells is  known as Merging. To
                 merge cells, follow these steps:

                 Step 1:   Select two or more adjacent cells that you want to merge.                Merging cells

                 Step 2:  Click on Merge & Center command in the Alignment group on Home tab.

                 The cells will be merged in a row or column, and the cell content will be centered in the merged cell.





                                                                                              More on Excel 2016   23
   20   21   22   23   24   25   26   27   28   29   30