Page 27 - PlugGPT_V2.0_C6_Flipbook
P. 27

Tech Funda




                       Font  Color  command  (         )  can  also  be  used  to  apply  color  to  text  of  the

                       selected cells.




                     CUSTOMISE WORKSHEET TAB


                 You can customise a worksheet tab in LibreOffice Calc. Calc allows you to rename a worksheet
                 tab, change the colour of the worksheet tab and delete a worksheet.
                 Step 1   Right-click the worksheet tab that you want to
                          customise.
                 Step 2   Select  the  Rename  Sheet  option  to  rename
                          the  worksheet  or  Tab  Color  option  to  change
                          colour  or  Delete  Sheet  option  to  delete  the
                          worksheet.  In  this  case,  we  are  renaming  the
                          worksheet tab.

                 Step 3   Type  the  name  and  press  the  Enter  key
                          from  the  keyboard.  The  worksheet  name  will
                          be changed.
                                                                                       Customising Worksheet tab
                     AUTOFILL

                 AutoFill  feature  automatically  fills  a  series  of  data  in  your  worksheet.  It  saves  your  time  by
                 completing the text or number series for you. Follow the below steps to use the AutoFill feature:
                 Step 1  Enter the first two numbers you want to start the series with.

                 Step 2  Select both the cells containing the numbers you have entered.
                 Step 3  Position the mouse pointer over the bottom-right corner of the last selected cell.
                          The pointer changes to (+) sign.

                 Step 4  Drag the mouse pointer over the cells you want to include in the series. The cells display
                          the number series automatically. This feature can be used to fill series of odd numbers,
                          even numbers, number series, days of a week, months of a year, etc.















                                        Applying            Number series           Days in a week
                                         AutoFill            using AutoFill         using AutoFill



                                                                                      More on LibreOffice Calc       25
   22   23   24   25   26   27   28   29   30   31   32