Even easier is to enter the 1 and 2 as Tom suggests then select those two
cells and double-click on the fill-handle(bottom-right corner of cell).

No dragging involved if adjacent column has contiguous data to row 4000.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 14:32:51 -0400, "Tom Ogilvy" wrote:

Easiest in my opinion is to put 1 in an adjacent cell in the first row, 2 in
the second row, then select 1 and 2 and drag fill down to the last (4000th
cell). Then select both columns and sort descending on the new numbers.
You could insert a column for this, then delete it.