4.6.5. > Formatting

• 'Autofilling'

Fields remaining constant for an entire list, such as the Agency and Accession fields, can be autofilled by MS Excel. This is an excellent timesaving technique when compiling large lists.

• Autofilling Text

• Enter the text in the first cell of the appropriate column, and press 'Enter'.
• Using the arrow keys or the mouse, highlight the box in which the value has just been entered.
• Using the mouse, move the thick, white '+' cursor onto the lower right corner of the cell and drag it down to fill as many cells as required.

• Autofilling Numbers

When autofilling numbers, you may find that the option outlined above adds numbers sequentially, e.g. 1 would become 2, then 3, then 4, etc. To avoid this you can use the following alternative:

• Enter the information to be autofilled.
• Hold the 'shift' key down and use the arrow down key to highlight as many cells as required.
• Press 'control' 'd' to autofill the information into the highlighted cells.