Page 280 - Computer - 9(A&B)
P. 280

To apply a text control option:

            Step 1:  Select the desired cells.
            Step 2:  Click on Format menu and select Cells option.
            Step 3:  In the format cells dialog box, select Alignment tab.
            Step 4:  Under Properties section, choose the required option.
            Step 5:  Click the OK button.



                         Wrap text ON, Multiple
                         lines in a single cell
                                                                                                Shrink to Fit









            Speeding up Data Entry Using AutoFill
            The AutoFill feature of Calc is used to quickly fi ll a predefi ned series of data such as text or numbers in a
            worksheet. For example, you can fi ll the days of a week, months of a year, or numbers in a pattern using AutoFill.
            When you move the mouse pointer to the lower right corner of selected cells, the mouse pointer’s shape changes
            to a + shape. This is called the Fill handle. You just need to drag the Fill handle to use the AutoFill feature.
            Filling a Number Pattern

            Step 1:  Enter the fi rst two values of data into two adjacent cells and press the Enter key. Select both the cells.
            Step 2:  Drag the Fill handle to enclose the desired cells to be fi lled with the series of numbers.

























            Filling Days/Months
            Step 1:  Enter the fi rst value of day or month in a cell and press the Enter key. Select the cell.
            Step 2:  Drag the Fill handle to enclose the desired cells to be fi lled with the series.











               142
               142
   275   276   277   278   279   280   281   282   283   284   285