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