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.
Excel Dice Tutorial: Formatting Your Cells to Look Like Dice
Step 1: Center the text: Select cell A1 and center horizontally and vertically.
Step 2: Make the number bigger: Select cell A1, change the font to Times New Roman (or any font of your choice), font size to 28 and make it bold.
Step 3: Add a border: From the drop down menu for borders, select ‘Thick Outside Border’. This formatting actually looks better if you do it outside of Column A, Row 1 so use format painter to move your die into cell B2 and then clear A1 (or follow the steps above again)
Step 4: Copy and paste the cell into D2, and now you have a set of dice ready to play your game of Cluedo! Just press F9 to roll.