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.
--
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

"Dab" wrote in message ...
No, actually, I meant drag down. In my example, I dragged the first two
rows across, then dragged down.

--
Dab

Cut off: yourhead to respond
"David McRitchie" wrote in message
...
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" wrote l...
Your right, I should have said: drag down to 2000, not to 1999. That
would
resolve the problem.