Page 248 - IT_Play_V1.0 Class9
P. 248

Step 4:  Drag it down or across to fill the series. In our case, we dragged the series down to cell A5 and then
                      released the mouse button.
























              Custom List

              In LibreOffice Calc, a custom list allows you to create a pre-defined series of values (such as days of the

              week, months, or any custom data) that can be automatically filled when you start typing a value and
              use the Auto Fill feature. A user can create his list as per his needs, like a list of a company’s branch
              offices. After the creation of the customised list, it can be used to fill a range of cells. To do so, we
              simply enter the first name in the list and drag the Auto Fill Handle.

              The pre-defined series will be displayed due to Auto Fill. To create a    1

              Custom list:
              Step 1:  Click on the Tools menu from the Menu bar.

              Step 2:  Select the Options button from the drop-down menu. The Options
                      dialog box appears on the screen.

              Step 3:  Click on the + beside LibreOffice Calc.
              Step 4:  To generate your own list, click on the New button.


                                                                         4

                            3













              Step 5:  Fill the series in the Entries section.                          2
              Step 6:  Click on the Add button.







                246     Information Technology Play (Ver 1.0)-IX
   243   244   245   246   247   248   249   250   251   252   253