Page 65 - iPro_trackGPT_V5_Class7
P. 65

Set Column Width/Row Height

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


                       1  Select the
                      column(s) or
                      row(s) whose
                                                                                2  Click on the
                      width or height
                                                                               Format command
                      you want to
                                                                               in the Cells group.
                      change.

                                                                                  3  Select Row
                                                                                 Height or
                                                                                 Column Width
                                                                                 under the Cell
                                                                                 Size section.


                   4  Type the value in the Row Height   5  Click on OK button.
                  or Column Width text box.


                 Automatically Fit Column/Row Content
                 To fit automatically column/row content, follow the given steps:

                                                                            Boost Bits
                                    2  Double-click any
                                                                      When a cell displays  #####, it usually
                                   boundary between two
                                   column/row headings.               means that  the number  or  date  in the
                                                                      cell is too  large  to  fit within the  current
                    1  Click on                                       column width. To view the full content in
                    the Select                                        its correct  format,  you  need  to  increase
                    All button.                                       the column width.




                    INSERTING ROWS/COLUMNS

                 Let us now learn about inserting rows and columns in a worksheet.
                 Inserting Rows

                 To insert a row in a worksheet, follow the given steps:


                                       2  Click on the Home tab.




                                                                                                 3  Click on the
                                                                                                Insert command.

                     1  Select the row
                    heading where you                                                            4  Select the Insert
                    want to insert a                                                            Sheet Rows option.
                    new row.




                                                                                         More on Spreadsheets    63
   60   61   62   63   64   65   66   67   68   69   70