Page 56 - TP-Play_V-2.0_Book-5
P. 56

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


                MERGING CELLS


            To merge cells, follow the given steps:

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



             56       Play (Ver. 2.0)-V
   51   52   53   54   55   56   57   58   59   60   61