Page 54 - TP_Play_V2.1_class5
P. 54

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.
                  Step 5: Click on OK button to get new row height / column width.

                                                                                      2




                                                                              3
                                           1






                                                             Setting column width


                                                         5         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


                   52       Play (Ver. 2.1)-V
   49   50   51   52   53   54   55   56   57   58   59