Excel can be set to automatically fill 'lists'
it recognises, for example, if you type Jan in
cell A1 and drag the 'fill handle' (small square
in bottom right of active cell) across twelve
columns, you will get Jan, Feb, Mar,
Apr.....etc. This is controlled from here.
Custom lists can be useful if you are always
typing repetitive information, perhaps as row
and/or column headers.
You can see in the dialog above, I have set
up a three item list, (Test1 to 3). Now if
I enter Test1 in a cell and drag the fill handle
down, it will fill in the others automatically.
If I drag past three cells, it will start at
Test1 again.
Lists can be added manually, by typing the
entries, each on one line, in the 'list entries'
box and pressing 'Add'. You can also type them
on a worksheet and import it by clicking in the
'Import list from cells:' box, select the data
and clicking 'Import'.
Any lists no longer being used can be
selected under 'Custom lists' and click the
'delete' button |
