Entering Values Quickly with AutoFill : AutoFill « Editing « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Editing
3. AutoFill

Enter 10 in A1. 
           Position the pointer on the lower-right corner of the selected cell. 
           The pointer changes to the fill handle.

Drag the fill handle over the range you want the value repeated.

2.10.AutoFill
	2.10.1.	Entering Values Quickly with AutoFill