How do I create numbers for a Chinese Auction?

[Guest]

 

[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
__

 

[Gord Dibben]

Boothie

Do you mean slips of paper with numbers printed upon?

Post back with more detail.


Gord Dibben Excel MVP

 

[Guest]

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

 

[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