Page 37 - TP_Modular_V2.1_Class7
P. 37

Step 3   Choose Column Width or Row Height
                          under  Cell Size  section from the

                          drop-down list.
                            A Column width or Row height dialog
                          box will appear.
                 Step 4   In  the  Column Width  or  Row Height
                          box, type the value that you want  your                     Setting column width
                          column or row to be.
                 Step 5  Click on OK button to get new row height / column width.










                                           Row Height dialog box     Column Width dialog box

                                                                                               Select All button
                 Automatically Fit Column/Row Content
                 To set column width or row height automatically, click on the Select All
                 button. Double-click any boundary between two column/row headings.
                 All columns/rows in the entire worksheet will be changed to the new
                                                                                                Selecting entire work-
                 size.
                                                                                                        sheet
                  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.














                                                                                        Editing in Excel 2016     35
   32   33   34   35   36   37   38   39   40   41   42