Five tips for working efficiently with Excel's fill handle - TechRepublic

Drag it in the appropriate direction, as shown in Figure A, and Excel copies ... you might enter 1 in A1 and 2 in A2 to fix a pattern that increments by 1 -- 1, 2, 3, 4, ...

www.techrepublic.com