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.

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 Auto Fill In Excel 2010 and Word 2010 (RAND Function)

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.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *