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

COLUMN WIDTH AND ROW HEIGHT

            On a worksheet, you can specify a column width of 0 to 255 and a row height of
            0 to 409. This value represents the number of characters that can be displayed in
            a cell that is formatted with the standard font. The default column width is 8.43
            characters and the default row height is 15 points. If a column/row has a width or
            height 0, it is hidden, i.e., it is not visible in the grid.

            Set Column Width/Row Height

            To set column width or row height, follow the given steps:

            Step 1  Select the column(s) or row(s) whose width or height you want to change.

            Step 2  Click on Format command in Cells group from Home tab.
            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 column or row to be.

                                                                                2




                                     1
                                                                        3






                                                       Setting column width


                                                             4











                                    Row Height dialog box Column Width dialog box

            Automatically Fit Column/Row Content                                        Select All button

            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                        Selecting entire
            worksheet will be changed to the new size.                                          worksheet



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