Fill 2 first numbers (1 and 2) into column B;
Select both cells you entered numbers in;
Place cursor on lower right corner of selection (a cross is displayed);
Dobule-click. Unless there are gaps in column A, column B will be filled until end of current datarange.
|