Page 277 - open office
P. 277
In addition to the horizontal and vertical alignment, ‘Calc’ provides other text control options in the same
dialog box-Wrap Text, Shrink to fit, Text Orientation.
Option Action Implemented (if selected)
This option wraps the text in multiple lines to accommodate the text
Wrap Text
automatically within the column width by increasing the row height.
This option reduces the font size of the contents to accommodate it within
Shrink to fit Cell size
the column width.
This option helps to rotate the direction of contents in a cell. The user can
Text Orientation 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 and filled. These alignments can also be
applied by using the 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’.
Lab Assignment ‘n Activity Subject Enrichment
Complete the following activities and tick on the circle.
Start Calc and open an existing spreadsheet file Cricket .
Apply the following formatting on the content of the worksheet.
a. Font style should be ‘Arial Black’.
b. Font size should be of 14.
c. Typeface of the content should be ‘Bold Italic’.
d. Alignment of all the data must be ustified .
e. Set vertical alignment as ‘Middle’.
f. Save the workbook.
g. Exit from the Calc.
FORMAT CELL
The cell in spreadsheet can hold different types of data such as decimal values, percentage, textual values,
date & time, etc. The data present in the cell can be customized or formatted using the ‘Format Cells’ option.
Format Cell to hold Decimal Values
Following are the steps to format cell to hold the decimal values:
Step 1: Select the range of cells.
Step 2: Click on the ‘Format’ menu and then select the ‘Cells’ option.
Formatting Cells in Spreadsheet 277

