Page 202 - CA_165_V2.0_C9_Flipbook
P. 202
The contents will be displayed within the column width only. The data which
Filled
does not get accommodated in the cell width will be hidden in the sheet.
The contents will be displayed completely within the column width by
Justified
increasing the column width.
Choose any of the above options, as per the requirement.
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 OpenOffice 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 AutoFill handle tool and drag it over the range of cells to
fill the defined series, then release the mouse button. The series of
months will be displayed. (The given series is displayed because it is Drag
predefined/stored as a custom list)
200 Touchpad Computer Applications (Ver. 2.0)-IX

