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
   197   198   199   200   201   202   203   204   205   206   207