Page 190 - CA 165 ver 1.0 Class 9
P. 190
Similarly, click on the ‘Vertical’ drop down list. It opens with various vertical alignment options which
are given below:
Option Action Implemented (if selected)
Bottom The contents will be aligned towards the bottom of the row.
Top The contents will be aligned towards the top of the row.
Middle The contents will be aligned in vertically centered position.
The contents will be aligned according to the default settings type of
Default
data being entered.
In addition to the horizontal and vertical alignment, ‘Calc’ provides other text control options in the
same dialog box; i.e, Wrap Text, Shrink to fit, Text Orientation, etc.
Option Action Implemented (if selected)
This option wraps the text in multiple lines to accommodate it
Wrap Text automatically within the column width by increasing the row height.
This option reduces the font size of the contents to accommodate it
Shrink to fit Cell size
within the column width.
This option helps to change the direction of contents in a Cell. The
Text Orientation user can either type the degree of angle of rotation or drag the angle
indicator and display the content in the required position.
The most common text alignments are left, right, center, justified or filled. These alignments can also be
applied by using shortcut buttons from the formatting toolbar. To apply the required alignment, select
the content and click on the required alignment button from the ‘Formatting Toolbar’.
AUTO FILL
It is an additional feature in spreadsheet package like ‘Calc’ in which a certain
kind of predefined series of data such as name of months of a year, serial
numbers, etc. are automatically generated once the user feeds the initial
data.
To print series of months of the year:
Step 1: Type the initial data (month name) of the series in one cell.
Step 2: Select the cell. An AutoFill handle (a small black plus sign) appears
at the bottom-right corner of the selected cell.
Step 3: Click the Auto Fill handle tool and drag it over the range of cells to Drag
fill the defined series, then release the mouse button. The series of
months will be displayed. (The given series is displayed because it
is predefined/stored as a custom list)
188 Touchpad Computer Applications-IX

