Page 55 - TechPluse_C6_Flipbook
P. 55

Using Cell Styles

                 You can create a cell style that includes a custom border, colour and
                 formatting. Follow the below steps to do so:

                 Step 1   Select a cell or range of cells on which you want to apply a
                           cell style.

                 Step 2   Click on the Styles menu.
                 Step 3   Select a cell style from the different cell style options you
                           would like to apply to your spreadsheet.


                 Applying Cell Fill Colour
                                                                                                 Applying styles to cells
                 Perform the below steps to fill a colour to a cell:

                 Step 1     Select a cell or range of cells that you
                            want to apply or remove a fill colour
                            from.
                 Step 2     Click on the Format menu.

                 Step 3     Select the Cells option. The Format
                            Cells dialog box appears.

                 Step 4     Click on the Background tab.
                 Step 5     Click on the Color button. A colour
                            palette opens.

                 Step 6     Select a colour from the palette. The
                            selected colour will be shown in the
                            New section.
                                                                                         Applying cell fill
                 Step 7     Click on the OK button. The chosen color will be applied to the selected cells.



                  Tech

                    Funda
                                    LibreOffice Calc saves your 12 most recently selected custom colours. To
                                    quickly apply one of these colours, click the arrow next to Background
                                    Color command (           ) and then click on the colour that you want under
                                    Recent.


                 Applying Text Colour


                 Perform the below steps to apply text colour:
                 Step 1     Select a cell or range of cells, text or characters on which you want to apply a text
                            colour.




                                                                                      More on LibreOffice Calc       53
   50   51   52   53   54   55   56   57   58   59   60