make labels (increasing number) 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!

 

[Dab]

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.

 

[David McRitchie]

Good suggestion but you would lose every 50th label if done
exactly as indicated. Instead of starting across it would be
easier to start down so you have Full 0050 and Full 0100
at the bottom and then copy the two columns across until
you have Full 2000 on the bottom right (not Full 1999).

Excel does not do very well with printing labels onto label
sheets. If you are printing onto label sheets then it may take
a few tries on plain paper to get the alignment correct and
it may not work on another printer or at a later date.
--

 

[Dab]

Your right, I should have said: drag down to 2000, not to 1999. That would
resolve the problem.

--
Dab

Cut off: yourhead to respond

Good suggestion but you would lose every 50th label if done
exactly as indicated. Instead of starting across it would be
easier to start down so you have Full 0050 and Full 0100
at the bottom and then copy the two columns across until
you have Full 2000 on the bottom right (not Full 1999).

Excel does not do very well with printing labels onto label
sheets. If you are printing onto label sheets then it may take
a few tries on plain paper to get the alignment correct and
it may not work on another printer or at a later date.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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
that
is change
the

 

[David McRitchie]

Hi Dab,
You mean drag *across* until you see 2000 in lower right corner.

You had the across part exactly correct before so that you don't
have to worry about page breaks at rows. Because you don't really
care where the pages break on the columns, since each column
holds 50 numbered items without you worrying about page breaks.

 

[Dab]

No, actually, I meant drag down. In my example, I dragged the first two
rows across, then dragged down.

 

[David McRitchie]

The reason you would first select A1:B2 and drag down from row 1 to 50
is that is what you want to fit on a page vertically -- no calculations involved,
other than your seed cells in A1:B2..

Then keeping your selection of A1:B50 (or if you lose it you could select A:B)
then looking at lower right corner of filled cells drag to the right until you see
2000 -- done. Avoids having to go past where you want and then backing off.
You can go to whatever number you want to go to or continue going across
in the last step at a later time for a higher count.

It saves a few mental calculations and avoids your original problem of not
including every 50th label.