Excel auto-complete of long column

Select the top two cells.
Hover the mouse over the bottom right corner of the second cell till it changes to a cross-hair
Double click on the cross-hair.
Done.

1. Select the column and hit delete.
2. Type 1 into A1.
3. Go to Home | Fill | Series ...
4. Select columns and type 1048576 as the stop value, then OK out.

EDIT: Just FYI, the crosshair solution offered above does not work for me in Office 365.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

@Ali: Works for me in Office 365 ? However, it only replaces the existing values, whereas your solution fills every row down to row 1048576. But why would you want to populate over a million (empty) rows? I DID assume that the OP only wanted to replace the existing data ...

@MaartenRo: Thanks for the rep

Originally Posted by TMS

@Ali: Works for me in Office 365 ? However, it only replaces the existing values, whereas your solution fills every row down to row 1048576. But why would you want to populate over a million (empty) rows? I DID assume that the OP only wanted to replace the existing data ...

Maybe because I interpreted this differently:

and drag the selected range down to the last bottom cell

Dragging to 500 would not take long.