Enter 10 in A1.
Position the pointer on the lower-right corner of the selected cell.
The pointer changes to the fill handle.
![Enter 10 in A1. Position the pointer on the lower-right corner of the selected cell. The pointer changes to the fill handle.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Choose_How_To_Fill_Selection___Enter_10_In_A1_Position_Pointer_On_.PNG)
Drag the fill handle over the range you want the value repeated.
Click the AutoFill Options button.
![Click the AutoFill Options button.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Choose_How_To_Fill_Selection___Click_Autofill_Options_Button.PNG)
Then click the option you want.
![Then click the option you want.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Choose_How_To_Fill_Selection___Then_Click_Option_You_Want.PNG)