You will need to go through the pain once to set up a custom list. Enter
the data in a list and then go to toolsoptionscustom lists, enter the
range in the 'Import list from cells' box and click import...now it will
autofill like any other list Jan, Feb, Mar, etc.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Quality101" wrote in message
...
I have a need to use excel to track large quantities of welds on
construction
sites. These welds are identified by component and are numerically
tracked
by row and sequence (i.e., 1A, 1B, 1C, 1D....1J; 2A, 2B, 2C, 2D....2J;
etc).
There could most likely be 180-225 rows like this in a single component.
So
far, I have been unable to use Excel's auto-fill capability to prevent
from
having to enter each column individually. Any suggestions?