Page 33 - TP_Prime_v2.2_Class_6
P. 33

Step 3:   Choose  Column Width or  Row Height under  the  Cell  Size  section from  the
                          drop-down list.

                          A Column width or Row height dialog box will appear.

                 Step 4:   Type the desired value in the Column Width or Row Height box.









                                          Column Width Dialog Box      Row Height Dialog Box                                MORE ON EXCEL


                   Automatically Fit Column/Row Content


                 To automatically fill a column or content of a cell, follow these steps:

                 Step 1:  Click on the Select All button.                                 Select All button               31

                 Step 2:   Double-click any boundary between two

                          column/row headings.

                 Step 3:   All columns/rows in the entire worksheet will be
                          changed to the new size.                                     Selecting Entire Worksheet



                                    At  times, a cell  might display  #####.  This  can occur when the cell
                         Fun
                         Fact!      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



                 We can add rows or columns in our worksheet wherever we needs.
                   Inserting Rows


                 To insert a row in a worksheet, follow these steps:

                 Step 1:   Click on the row heading above which you want to insert a new row.

                 Step 2:  Click on the Insert command under the Cells group on the Home tab.

                 Step 3:  Select the Insert Sheet Rows option from the drop-down list.
   28   29   30   31   32   33   34   35   36   37   38