Page 245 - IT_Play_V1.0 Class9
P. 245

Step 2:  Click on the Format menu from the Menu bar.
                 Step 3:  Select the Cells option from the drop-down menu.

                         The Format Cells dialog box appears on the screen.
                 Step 4:  Click on the Alignment Tab.


                            2
                                                                                                            4
                                                                                                            5



                            1                                        3









                                                                                                            6



                 Step 5:  Click on the Horizontal drop-down list. It provides various horizontal alignment options like:


                     Option                                Action Implemented (if selected)
                                   The contents will be aligned according to the default settings of the type of data being
                    Default
                                   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 that does not get
                    Filled
                                   accommodated in the cell width will be hidden in the cell.
                                   The contents will be displayed completely within the column width by increasing the
                    Justified
                                   column width.
                    Distributed    The alignment spaces text evenly, across the cell's 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:

                       Option                              Action Implemented (if selected)

                      Bottom        The contents will be aligned towards the bottom side of the row.
                      Top           The contents will be aligned towards the upper side of the row.
                      Middle        The contents of the cell will be aligned in vertically centered position.

                                    The contents will be aligned according to the default settings of the type of data
                      Default
                                    being entered.
                      Distributed   The alignment spaces text evenly, across the cell's height.




                                                                                   Format Data in the Spreadsheet   243
   240   241   242   243   244   245   246   247   248   249   250