Calc Guide

Figure 28: 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 (Edit > Sheet > Select), then enter the information in
the current one.
Caution
This technique overwrites any information that is already in
the cells on the other sheets—without any warning. For this
reason, when you are finished, be sure to deselect all the
sheets except the one you want to edit. (Ctrl+click on a sheet
tab to select or deselect the sheet.)
48 OpenOffice.org 3.x Calc Guide