Software

When you need to work with random data, use Excel 2007's built-in RANDBETWEEN function

Excel 2007 includes the RANDBETWEEN function, which allows you to quickly add sample data to your worksheets. Mary Ann Richardson explains how you can work with this feature to get more out of your data.

Excel 2007 includes the RANDBETWEEN function, which allows you to quickly add sample data to your worksheets. (In previous versions of Excel, this function was available only after you installed the Analysis Tool Pack add-in.)

For example, say your worksheet contains a list of 14 customers in Column A and their corresponding purchases in Column B. Follow these steps to use the RANDBETWEEN function to add sample data to Column B:

  1. Click in Cell B2 and enter =RANDBETWEEN(0,100).
  2. Drag the fill handle at the bottom right corner to cell B15.

The sample data will remain in the worksheet until you close it. When you reopen the worksheet, Excel will recalculate the function and display new sample data. To prevent Excel from recalculating the values, follow these steps:

  1. Select B3:B15.
  2. Press [Ctrl]C.
  3. Click on the Home tab.
  4. Click Copy in the Clipboard group.
  5. Click Paste.
  6. Click Paste Values.
  7. Press [Esc].
Miss an Excel tip?

Check out the Microsoft Excel archive, and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox