random numbers / superbowl pool

[thefish3]

I am trying to create a superbowl pool spreadsheet. You've seen them a
superbowl parties or at the office. The 10x10 classic spreadshee
using the numbers 0-9 along the left-most column, and 0-9 across th
top row. I need the numbers 0-9 to be randomly generated. Does anyon
have any ideas for this spreadsheet

 

[Peo Sjoblom]

Don't know anything about Superbowl but here's a formula that will create a
random number between 1-9

=INT(RAND()*(10-1)+1)

it will recalculate so once you get a value, select the formula in the
formula bar and press F9 and then enter