If you use our All Possible and Best Bets lists to select number combinations to play in the lottery, you may find (as we do) that it’s easier to choose numbers to play when they are mixed-up instead of in sequential order as they are by default.

To perform this task you will need Microsoft Excel or a similar database/spreadsheet application. Before you begin we suggest that you back-up your All Possible and/or Best Bets lists to be sure you have a back-up copy in case something goes wrong while mixing the number combinations.

To begin, start Excel and open an All Possible or Best Bets list (you may have to select “All Files” from the drop-down list or text files won’t show-up). When prompted select “Delimited” then “Finish”.

With the number combinations showing in column A, type the following formula in column B

=RANDBETWEEN(1,75000)

Scroll to the bottom of the list then use Shift+Click to highlight column B. Next, use the “Fill Down” feature from the menu or use CTRL+D. You should now have a list of random numbers in column B.

To mix the number combinations we use the “Sort” feature of Excel. To do this select both A and B columns. Next select the Sort feature and click “Custom Sort” . In the next menu select “Sort By Column B” and “Sort Lowest to Highest” and click OK. The number combinations are now mixed-up. You can repeat the process to mix them up more, or delete column B and save the file.