View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default How do I number a table with 300 row (in a different column)

Yes,
In the first cell at the top of the group enter 1
For example's sake we'll say that was in cell A2
in the second cell, right below that (A3) enter
=A2+1
now drag down as far as you care to go.

There are slightly faster ways, but they are "if and depends on setup" kinds
of ways, so that's the sure, quick way.

"miki" wrote:

I want to add a column with numbers from 1-300 the fastest way, instead of
just writing down the numbers. Is there any wat ro start numbering and then
dra it till the 300 row???