Page 69 - iPrime_V2.2_class7
P. 69

Automatically Fit Column/Row Content
                                                                                          Select All button
                 Step 1  Click on the Select All button.

                 Step 2  Double-click any boundary between two column/
                         row headings. All  columns/rows in the entire
                         worksheet will be changed to the new size.
                                                                                         Selecting entire worksheet
                 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

                 Inserting Rows

                 To insert a row in a worksheet, follow these

                 steps:
                 Step 1  Select the row  heading where  you
                         want to insert a new row.
                 Step 2  Click on the Insert command in the
                         Cells group under the Home tab.
                 Step 3  Select the Insert Sheet Rows option
                                                                                   Inserting a new row
                         from the drop-down list.
                 A new row is inserted above the selected row and the existing rows shift downwards.













                                                           New row inserted
                 Inserting Columns


                 To insert a column in a worksheet, follow
                 these steps:
                 Step 1  Select the column heading where
                         you want to insert a new column.

                 Step 2  Click on the Insert command in the
                         Cells group under the Home tab.
                 Step 3  Select the  Insert Sheet Columns
                         option from the drop-down list.                         Inserting a new column

                                                                                         More on Spreadsheets      67
   64   65   66   67   68   69   70   71   72   73   74