Auto Fill In Excel 2010 and Word 2010 (RAND Function)

Microsoft Office suite applications provides an ability to auto-fill the documents and spreadsheets. In this post we will guiding you through the way to auto-fill Word 2010 Document and Excel 2010 Spreadsheet.

Excel 2010

Launch Excel 2010 and open a spreadsheet on which you want to quickly fill the desired fields. For instance we have included a spreadsheet having Reg No and Name fields.

table

Now we will be using RANDBETWEEN function that will randomly fill in the fields within specified range. The basic syntax of RANDBETWEEN function is;

=RANDBETWEEN(bottom,top)

We will be writing this function in the first row of field Reg No as;

=RANDBETWEEN(47,75)

The first argument is 47, which is the minimum value of the range and 75 is the max value. So the range would be from 47 to 75. It would show random number as seen in the screenshot below.

number

Now for applying it over the field just drag the plus sign at the end of the cell towards the column.

apply


The values in the field would constantly change, so in order to keep them intact just right-click the values, under Paste Options, click paste values button.

paste special

Word 2010

You need to write the same function in Word as;

=rand()

On pressing enter, you will see the auto-fill paragraph.

word

Another place holding text filler which has been widely used in web designing and other prototypes is;

Lorem ipsum dolor sit amet, consectetur adipisicing elit……

For filling Word document with this placeholder filler, you need to write it as

=lorem()

lorem

You can also check out previously reviewed guides on Embedding Excel Spreadsheet in Word 2010 & Import Spreadsheet to Word 2010.

Advertisement
  • Pingback: Word 2010 Change Font Color With Gradient Fill

  • Pingback: Add Fun with Cycle Font Colors In Excel 2010

  • Pingback: Insert Page Numbers In Word 2010 Document

  • Katie

    I was trying to turn on ‘auto fill’ as in Word 03-07. No information for what I’m looking for anywhere.

  • Yvonne

    Trying to find way to turn on ‘auto fill’ in Word 2010 for names of months and days of week. It worked in Word 2007. Didn’t find answer here. Where do I go next?

  • Pingback: Create Macros In Word 2010

  • amy

    this is to compicated for the normal computer user not user friendly at all

    • Renee Wenker

      I agree. I just want to know how to establish a function that automatically fills a series of selected cells by adding 1 to the previous cell’s number. My macros are messed up because of the manual “fill series” criteria. I need the fill series automated, with only one cell, containing 1 number. Anyone?

  • DiveGirlBlue

    Hi, I’ve been struggling with this. Just worked it out
    Tab: Formulas
    Box: Calculation options – select automatic
    Tah dah :)