1. Home
  2. MS Office

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.

Leave a comment