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

