numbering


Posted by E Buss on January 18, 2002 6:52 AM

I want to number a column from 1 to 4000. What's the easiest way to do that?



Posted by IML on January 18, 2002 7:07 AM

1 way is to put 1 in cell a1, right click on the handle, drag down to cell A4000 and select fill series.

Another way it put 1 in cell a1 and remain in cell a1, type A4000 in name box directly above A1, hit shift and enter. While hold down Alt, key in EIS.