DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)
Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Set (fill) Cells of a Range to Random Values

Select one or multiple ranges, set the cells in the selected area to random values. DigDB allows you to set boundaries of the values, and with options to:

Generate random integer number values
  1. Select one or several ranges. Use Ctrl+Select to select multiple ranges. Invoke 'DigDB->Selected Area->Set Cells to->Random Values...'

    Set (fill) Random Values
    Practice file - fill-random-demo.xls (16k)

    Set (fill) Random Values

  2. Enter the boundary values you want. The random value defaults to integer numbers. You can use the dropdown to change to date values. Uncheck the 'Values in Integer or Day' checkbox to generate random number with decimal or day with time.

    Set (fill) Random Values

  3. Result - all cells in selection will be overwritten.

    Set (fill) Random Values

Generate random decimal number values
    Fill the current selection with random decimal values between 0 and 1. Set the boundary to 0 and 1; uncheck the 'Values in Integer or Day' checkbox.

    Set (fill) Random Values
    Practice file - fill-random-demo.xls (16k)

    The 0 and 1 in result are decimal values. Click Excel's 'Format->Cells' to format the selected range to 'General' or any number format you want.

    Set (fill) Random Values

    Set (fill) Random Values

Generate random day-only date values
    Fill the current selection with random day-only date values between 10/26/03 to 10/26/04. Change the dropdown to 'Dates', set the boundary values.

    Set (fill) Random Values
    Practice file - fill-random-demo.xls (16k)

    Set (fill) Random Values

Generate random day-with-time date values
    Fill the current selection with random time values within a day. Change dropdown to 'Dates'; set the boundary values to between: 10/25/04 00:00 and 10/26/04 00:00 (note the 10/25/04 24:00 is NOT a valid time format); uncheck the 'Values in Integer or Day' checkbox.

    Set (fill) Random Values
    Practice file - fill-random-demo.xls (16k)

    If the filled values show as '10/25/04', it's just a formatting issue. Those values are day-with-time values. Click Excel's 'Format->Cells' to format the selected range to 'General' or choose the time format you want.

    Set (fill) Random Values

    Set (fill) Random Values

Need more?

Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.