Generate an Index Column

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

How can I quickly get an index column running from 1 to
(end of data)? I need this for sorting spacey data and
getting rid of the blank lines. Then I restore the
original order with a sort on the index column. Now I can
only generate the column with an autofill drag - takes a
long time.
 
Hi
one way:
if you want your index in column A (your data is in column B) try the
following:
- enter a 1 in A1 and a 2 in A2
- now select A1 AND A2
- double click on the lower right corner of this selection
 
Back
Top