Page 33 - ModularV1.1 _c6_flipbook
P. 33

Clickipedia



                   At times, a cell might display #####. This can occur when the cell contains a number or
                   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 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                     Inserting a new row
                         inserted above the selected row and the existing rows shift downwards.


                 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  the  Insert command in the
                         cells group under the Home tab.

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

                     MERGING CELLS

                 To merge cells, follow these steps:
                 Step 1  Select two  or  more  adjacent  cells

                         that you want to merge.
                 Step 2  Click on Merge & Center command
                                                                                      Merging cells
                         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.
                                                                                                   Merged Cells
                 Split Cells

                 Step 1  Select the merged cell you want to split.



                                                                                             Editing in MS Excel  31
   28   29   30   31   32   33   34   35   36   37   38