You can do the entire table with two drags!

Just enter the first two values in the first two columns

Full 0001 Full 0051
Full 0002 Full 0052

Select all 4 cells, then click the lower right hand corner of the selection,
and drag to the right until you get to 1951 in the first row. This may take
a few tries to get to 1951, but you can stop, then drag forward or backward
until you reach 1951. You should now have the first two rows of all the
columns you need. and the first two rows will be selected.

Without undoing your selection, simply drag down until you get to 1999 in
the bottom right hand corner cell. Your table will be complete.

Its very quick.

--
Dab

Cut off: yourhead to respond
"Matthew Louden" wrote in message
...
I want to make labels in the following format using Excel. What I did was
type the first row number (e.g. Full 0051) and then drag the mouse so that
the number will be increasing. But I have to do it in every column, that
is
tedious work. Anyone knows faster way to do that? Also, how can I change
the
size of each cell consistency?

Full 0001 Full 0051 ... Full 1951
Full 0002 Full 0052
... ...
Fulll 0050 Full 0100... Full 2000

Thanks!