Figure 113: Predefined fill series
Click New. The
Entries
box is cleared. Type the series for the new list
in the
Entries
box (one entry per line), and then click Add.
Figure 114: Defining a new fill series
Using selection lists
Selection lists are available only for text, and are
limited to using only text that has already been entered
in the same column.
To use a selection list, select a blank cell and press
Ctrl+D
. A drop-down list appears of any cell in the same
column that either has at least one text character or
whose format is defined as Text. Click on the entry you
require.
Sharing content between sheets
You might want to enter the same information in the same cell on
multiple sheets, for example to set up standard listings for a group of
individuals or organizations. Instead of entering the list on each sheet
individually, you can enter it in all the sheets at once. To do this, select
all the sheets, then enter the information in the current one.
Chapter 5 Getting Started with Calc 149
Comments to this Manuals