Page 315 - TP_IT_V1.0_C9_flipbpookl
P. 315

Formatting the Alignment of the Cells
                 The default alignment of the data in a cell can be easily changed by using the alignment tools
                 (Align Left, Align Center, Align Right, Align Top, Center Vertical, Align Bottom) present on the Formatting toolbar or by
                 using the Format Cells dialog box.
                 The steps to align the data in a cell are as follows:
                 Step 1:  Select the desired range of cells.

                 Step 2:  Click on the Format → Cells option from the Menu bar.
                         The Format Cells dialog box opens.
                 Step 3:  Select the Numbers tab.
                 Step 4:  Select the Horizontal and Vertical options under the Text alignment section.
                 Step 5:  Click on the OK button.

                 The text is aligned according to the specified alignments.




























                 The Wrap text automatically option wraps the text in multiple lines to accommodate the text automatically within the
                 column width by increasing the row height. The Shrink to fit cell size option reduces the font size of the contents to
                 accommodate it within the column width.


                                         To align the text in the cell:


                                     Short key  Left:  Ctrl  +  L       Right:       Ctrl  +  R





                                         Center:     Ctrl  +   E        Justify:     Ctrl  +  J







                          uiz Bee        What are the different alignment options in LibreOffice Calc?






                                                                                               Electronic Spreadsheet  313
   310   311   312   313   314   315   316   317   318   319   320