make labels in excel

[Matthew Louden]

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!

 

[Dave Peterson]

I'd use a formula. Put this in A1 and copy down and to the right:

="Full " & TEXT((COLUMN()-1)*50+ROW(),"0000")