Using AutoFill with Identical Data In Excel

Quantunet.com

Excel 2003 QuickSkills

Using Autofill Identical fill

How to autofill cells with identical data:

Hold down the left mouse button and drag over the contents at least two cells with identical information.
Left click and drag the fill handle over the cells you want to fill (The small back square in the bottom right corner of the box highlighting the cells).
Release the mouse button.