How do I create numbers for a Chinese Auction?

R

Richard Buttrey

On Tue, 22 Nov 2005 13:23:09 -0800, "Boothie"

It might assist if you explain what *you* mean by a Chinese auction.

Rgds

Richard Buttrey
__
 
G

Gord Dibben

Boothie

Do you mean slips of paper with numbers printed upon?

Post back with more detail.


Gord Dibben Excel MVP
 
B

Boothie

Yes, I need to have 10 squares of each number from 1-200. Buyers will
purchase 10 chances for $1. I know there is an easy way to do this, but
can't remember the formula. Thanks
 
G

Gord Dibben

In a new worksheet.

in A:E1 enter 1 through 5

In A2 enter =A1+6

Drag that across to column E then drag down to row 40.

You now have the numbers 1 to 200

Format for Hozizontal and Vertical centered under Format>Cells>Alignment.

Select the 5 columns 40 rows and play with height and width until you get
squares that fit the page. Probably about 50 per page.

Set the Font size to about 36.

Set up your margins top and bottom through File>Page Setup>Margins

Print it out and start cutting.


Gord Dibben Excel MVP
 
Top