Page 189 - CA 165 ver 1.0 Class 9
P. 189

To align the data of cell:

                 Step 1:     Select a cell or range of cells to be aligned and click on the ‘Cells’ option from the ‘Format’
                          menu. ‘Format Cells’ dialog box appears as:

                                     2

































                 Step 2:   Click on the ‘Alignment’ Tab.
                 Step 3:   Click on the ‘Horizontal’ drop down list. Different type of horizontal alignments are given
                          below in table.


                          Option                             Action Implemented (if selected)

                                           The contents will be aligned according to the default settings of the type
                    Default
                                           of data being entered.


                    Left                   The contents will be aligned towards the left side of the cell.


                    Right                  The contents will be aligned towards the right side of the cell.


                    Center                 The contents will be aligned towards the center of the cell.
                                           The contents will be displayed within the column width only. The data
                    Filled                 which 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.






                                                                                    Working with Spreadsheet     187
   184   185   186   187   188   189   190   191   192   193   194