Use this Microsoft Excel tutorial to create your own dice roller, but why would you need to use Excel to roll your dice?

You’ve decided to have a family night in and play Cluedo. You open up the box, set up the game and go to start. One problem: you’re missing the dice. You frantically check all the other games; Monopoly,  Yahtzee, Risk and even Battleships – which doesn’t even have dice. As usual, there are none to be found – they’ve all disappeared. Probably down the back of the sofa or under some boxes in the wardrobe.

For some, this means that family night is over. For others, it’s time to open up Excel and create their own dice roller!

How to create a dice roller in Microsoft Excel 2007

Step 1: Open up a blank spreadsheet in Excel.

Step 2: Select cell A1. From the Cells Menu within the Home Tab, select ‘Row Height’ from the Format drop down and enter 41. This makes all of Row 1 square cells.

Step 3: Enter the formula =INT(RAND()*6)+1 into cell A1.

Step 4: Press F9 to roll your die, simply copy the formula into another cell if you want two or more dice. While you do have your dice working now, they don’t look very dicey, so here are some quick tips for formatting the cell. This is a great chance to show your kids (if you have any!) how to do some basic tricks in Excel. Read the rest of “How to Create a Dice Roller in Microsoft Excel 2007″